Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
papillon2811
Starting Member
18 Posts |
 Posted - 2007-01-24 : 04:37:38
|
| HiI have created one SSIS package which extract data from database and put that into verious text files like Emp.txt,Add.txt like that.Also I set one globle veriable (CityID) that help in extracting data as citywise.When I ran it through command prompt by passing globle veriable to it like C:\setup pca\SSIS Packages\SSIS Package File Extract Data\SSIS Package File Extract Data>DTExec /FILE Package.dtsx /SET \Package.Variables[CityID].Value;100it gives me data whose CityID is 100 and format it into text files.but when i want data for another CityID (101) it overwrites my all previous text files where i kept that files.Now my requirment is that i want to set another globle veriable that take PATH as input parameter and place these files in that path location.(How i set this path in command promt and also in SSIS)Please guide meThanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-24 : 09:56:21
|
| In the flat file connection set the connection string from the variable in an expression.You can also just use the cityID to construct the filename.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Passing path as input parameter