loveindia Posted March 25, 2014 Author Report Posted March 25, 2014 Trying to post a demo article soon, how to use SSIS as a data source... Stay tuned... sada mee premaku baanisaaa love india babu...
Vinuu Posted March 25, 2014 Report Posted March 25, 2014 nuvvu eppudu antey appudu... cheppu.. evadiki undedi aadiki untadi .. gaadidha guddu... :)
libraguy863 Posted March 25, 2014 Report Posted March 25, 2014 Script task output to a dataflow task variable passing , have you come across this situation bro??
loveindia Posted March 25, 2014 Author Report Posted March 25, 2014 Script task output to a dataflow task variable passing , have you come across this situation bro?? nee question okka mukka ardam kaaledu man...
pachimirchi Posted March 25, 2014 Report Posted March 25, 2014 Script task output to a dataflow task variable passing , have you come across this situation bro?? script task use chesi populate chesina variable ni dataflow lo use cheyyali ide na nee question? No matter how you populate a variable, it can be used in subsequent controls and it reflects updated value too..
loveindia Posted March 25, 2014 Author Report Posted March 25, 2014 Script task output to a dataflow task variable passing , have you come across this situation bro?? do you to see the value of the variable at run time using script task ?? if that is ur question follow this link man... http://sqlsaga.com/ssis/how-to-display-the-value-of-a-variable-using-a-script-task-in-ssis/ just after your Data flow task, use a script task and print it on the screen.... or data flow task lo variable ni change cheyyadam ela antey use this.... http://sqlsaga.com/ssis/how-to-generate-an-incrementing-number-in-ssis-using-a-script-component/ if you want another way, use break points and use watch windows....
loveindia Posted March 25, 2014 Author Report Posted March 25, 2014 SQL guru ..... Thanks nice thread tittavaa pogidaava man....
Ramki123 Posted March 25, 2014 Report Posted March 25, 2014 Pogidanu Bhiya... DB lo Time waste post lu a kakunda ... illa help avthai
libraguy863 Posted March 25, 2014 Report Posted March 25, 2014 do you to see the value of the variable at run time using script task ?? if that is ur question follow this link man... http://sqlsaga.com/ssis/how-to-display-the-value-of-a-variable-using-a-script-task-in-ssis/ just after your Data flow task, use a script task and print it on the screen.... or data flow task lo variable ni change cheyyadam ela antey use this.... http://sqlsaga.com/ssis/how-to-generate-an-incrementing-number-in-ssis-using-a-script-component/ if you want another way, use break points and use watch windows.... No that was not my question, i have a list of values for 1 to 10 in a table and using a scripttask i shred the values in the table and pass 1 value at a time to DFT into a variable carrying a SQL query, the main reason is to make it hands free as of now im using a for each loop passing 1 at a time to the DFT but if i have 10,000 it is not performance effective so...
Suhaas Posted March 25, 2014 Report Posted March 25, 2014 Keep up the good work bhayya. Sqlsaga.com is very informative.
loveindia Posted March 25, 2014 Author Report Posted March 25, 2014 No that was not my question, i have a list of values for 1 to 10 in a table and using a script task i shred the values in the table and pass 1 value at a time to DFT into a variable carrying a SQL query, the main reason is to make it hands free as of now im using a for each loop passing 1 at a time to the DFT but if i have 10,000 it is not performance effective so... why are you passing it to the query one value at a time?? if you have 10000 values, that means it is 10000 loops... can you not have all that values into a table and use a join directly over that table... which will eliminate looping....??? are you passing that variable value to a direct sql query???? believe me this way will be 10X faster than what u r doing now....
loveindia Posted March 25, 2014 Author Report Posted March 25, 2014 Keep up the good work bhayya. Sqlsaga.com is very informative. thanks man for the feed back...
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts