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 |
|
mafeltz
Starting Member
7 Posts |
 Posted - 2009-06-29 : 15:18:43
|
| I have created a dtsx package that imports data from a flat file, does some data manipulation and outputs that data into a table. This package runs prefectly but now I am going ot have to run this same import now on a daily basis on a flat file that comes named YYMMDD.txt. I also have to use the filename without the extension 'YYMMDD' to populate a column in final table. I am not familar enough with varaibles to know how to take the filename (minus the extension) save it as a variable and then call that variable later to import into my table. I have thought about writing the 'YYMMDD' variable i need to a flat file as well and then importing to the table from the text file, but again i am having no luck setting up a variable and exporting it to a file. So my first question would be - How do i write my filename to a flatfile or store in memory for later use?Secondly If the variable is store in memory for later user and i am not importing into a table from a flatfile how do you call the variable when needed?Any help/assistance would be appreciated.Thanks, Mike |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-30 : 14:07:32
|
| seems like what you're looking for is thishttp://www.sqlis.com/post/Easy-Package-Configuration.aspx |
 |
|
|
mafeltz
Starting Member
7 Posts |
Posted - 2009-07-15 : 10:16:26
|
| thanks for the reply, that was not was i was looking for but was able to make it work using some dos commands and calling them from the SQL server |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-15 : 13:42:56
|
| so were you asking about passing parameter values through command mode? |
|
|
|
|
|
|
How to use variables in SQL 2005 IS?