loveindia Posted August 26, 2015 Report Posted August 26, 2015 You can use only global temp tables for this man... for that you have to connect to temp db (which is not good practice).. you can use RECORDSET DESTINATION and use script task to deal with that data and then use other dataflow's to load data to your end table. and yes you can acheive what you want in ssis but with script task (for sure) , tables toney kaavali antey, you can still do but lot of things you have to take care of... but you have to atleast create the temp tables using EXECUTE SQL task man... no other choice...
loveindia Posted August 26, 2015 Report Posted August 26, 2015 Nenu ssis package loo excel ni script component too read chesta as source..ala cheyamni cheppadu naa mestri..vadi pichianandam probably he is looking into compatibility of excel emo man... There are many people who prefer to use excel in script, its much easier and faster as it is in-memory...... also to run through different sheets quickly...
Darling999 Posted August 26, 2015 Author Report Posted August 26, 2015 script task chestey simple bhayya, but pressure ekkuva malli dll's ni call chestadi urikey...trying for alternative with multiple sources You can use only global temp tables for this man... for that you have to connect to temp db (which is not good practice).. you can use RECORDSET DESTINATION and use script task to deal with that data and then use other dataflow's to load data to your end table. and yes you can acheive what you want in ssis but with script task (for sure) , tables toney kaavali antey, you can still do but lot of things you have to take care of... but you have to atleast create the temp tables using EXECUTE SQL task man... no other choice...
sqladdict Posted August 26, 2015 Report Posted August 26, 2015 probably he is looking into compatibility of excel emo man... There are many people who prefer to use excel in script, its much easier and faster as it is in-memory...... also to run through different sheets quickly... mavadu...column names in excel ni..dynamic gaa linq too extract chestadu...vadiki mati bhraminchindi...users csv files create chestam antey....vaddu we will do it in excel ani kathalpadutundu
loveindia Posted August 26, 2015 Report Posted August 26, 2015 mavadu...column names in excel ni..dynamic gaa linq too extract chestadu...vadiki mati bhraminchindi...users csv files create chestam antey....vaddu we will do it in excel ani kathalpadutundu Metadata change avutundi antey tappa em laabham ani adagakoodadaa man..
loveindia Posted August 26, 2015 Report Posted August 26, 2015 script task chestey simple bhayya, but pressure ekkuva malli dll's ni call chestadi urikey...trying for alternative with multiple sources Yy man?? Are you calling any third party dll's?? Internal vaatiki em anta undadu man.. inka alternative antey create temp tables and use them in data flows... and create a master flow using all of them..
4Vikram Posted August 26, 2015 Report Posted August 26, 2015 Metadata change avutundi antey tappa em laabham ani adagakoodadaa man.. vuncle man how are you long time no see
loveindia Posted August 26, 2015 Report Posted August 26, 2015 vuncle man how are you long time no see Vikram man nenu ichata kusalamey.. néevachata kusalamaa...
Raja123 Posted August 26, 2015 Report Posted August 26, 2015 Konchem ikadiki randii oka package cheyyali ideas kaavali..
4Vikram Posted August 26, 2015 Report Posted August 26, 2015 Vikram man nenu ichata kusalamey.. néevachata kusalamaa... nenu kusalame, pelli degara padtundi anukunta.....
sqladdict Posted August 26, 2015 Report Posted August 26, 2015 Yy man?? Are you calling any third party dll's?? Internal vaatiki em anta undadu man.. inka alternative antey create temp tables and use them in data flows... and create a master flow using all of them.. ma vodu script task use chestadu for data cleansing, file validtion...script task loo .net sonta methods/functions define chestadu...vedi too pani chestontey...ssis alla .net developwr aytattu vunna
sqladdict Posted August 26, 2015 Report Posted August 26, 2015 Yy man?? Are you calling any third party dll's?? Internal vaatiki em anta undadu man.. inka alternative antey create temp tables and use them in data flows... and create a master flow using all of them.. mavadiki temp tables ani topic ettitwy face red avvudi..em chestam vadi toka pattukoni missisippui river swimming
sqladdict Posted August 26, 2015 Report Posted August 26, 2015 Metadata change avutundi antey tappa em laabham ani adagakoodadaa man.. hmmm.vadiki kick kosam..tapadu
Recommended Posts