Ssis Help Please,.,.,,.,

[12ka4]

Hello All,
I have a table like country_Name|year|grp_Id|Period, like this 10 rows.I need to pass these 4 values as parameters in ssis package at run time and my package needs to execute total 10 times as there are total 10 rows in that table .With the data flow task, I used a source query as select * from some_Master_Table where country_Name=? and year=? and grp_id=? and period=? and the target is an excel. So my output should be total 10 excel files. And here, first Country_Name folder needs to create in that a year folder in that a grp_id folder and in that a period folder and here my excel file (from DFT with where country_Name=? and year=? and grp_id=? and period=?) has to be placed.
Any help would be appreciated.

Thanks,

[bePLUS+]

[JUJUBI_JULABI]

for each loop container gurinchi chaduvu .. and if you have those parameter values in table then u can store those values in paramets and pass them ..

[12ka4]

for each loop use chesi try chesa,okate folder lo okate excel file lo motham output vachesthundi ,separate excel files create avvadam ledhu, and separate ga folders ela create avuthayoo kuda ardham kavatledhu,,.,.

[JUJUBI_JULABI]

[quote name='12ka4' timestamp='1339007626' post='1301922674']
for each loop use chesi try chesa,okate folder lo okate excel file lo motham output vachesthundi ,separate excel files create avvadam ledhu, and separate ga folders ela create avuthayoo kuda ardham kavatledhu,,.,.
[/quote]

i dont think you can create a folder from SSIS, okatey folder to diff excel ki matram cheyochu ... connection string dynamic undali .. dont point to one excel file

[mtkr]

[Anta Assamey]

[12ka4]

I can create a single folder dynamically,but not multiple folders,..,.

[JUJUBI_JULABI]

[quote name='12ka4' timestamp='1339008137' post='1301922734']
I can create a single folder dynamically,but not multiple folders,..,.
[/quote]

Can you put the same code in for each loop and try to change the folder name in the connection string ?

[12ka4]

here the problem is, I need to take the input for the folder name from variables that I linked to for each loop for the DFT execution.

[JUJUBI_JULABI]

[quote name='12ka4' timestamp='1339008549' post='1301922770']
here the problem is, I need to take the input for the folder name from variables that I linked to for each loop for the DFT execution.
[/quote]

yeah nuvvu connection string expression rasthav kada akkada @variablename use cheyochu ..

[JUJUBI_JULABI]

[url="http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/63152/"]http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/63152/[/url]

login id create chesko

[12ka4]

thanks for the reply. I used the same link to create a folder. But I don't know how it works for multiple folder creation,.,.,

[Ranga_The_Donga]

[quote name='JUJUBI_JULABI' timestamp='1339008745' post='1301922791']
[url="http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/63152/"]http://www.sqlserver...s (SSIS)/63152/[/url]

login id create chesko
[/quote]
shoot... nenu ippude e link vedham anukunna....

[JUJUBI_JULABI]

[quote name='12ka4' timestamp='1339008864' post='1301922806']
thanks for the reply. I used the same link to create a folder. But I don't know how it works for multiple folder creation,.,.,
[/quote]

am pretty sure we can create new folder each time .. the trick is for each variable defined create a new folder and pass the variable name in the expression so that each time each new folder is created .. connection ela dynamic cheyalo google chesi chudu .. pass cheyyi name a connection ki ...