December 21, 2009 at 9:38 am
Hi ALl,
I am created a ssis package that is loading a file into Db table
(But every thing is hard coded e.g in Flatfile source i am mentioned file name)
and destination i am mentioned Table name , But
How to pass Input file NAme and Tbale name at run time?
December 21, 2009 at 1:09 pm
The two ways we've done this are:
1) Writing the filenames as the contents of another file that you use as a source in the SSIS package.
2) Writing the filenames to a SQL table that you use as a source in the SSIS package.
...hope this helps
December 22, 2009 at 12:07 pm
Thanks for reply,
But can we use variables and map file names to those variables or
any XML configuration?
December 30, 2009 at 12:08 pm
I think, this link will help you.
http://www.simple-talk.com/sql/ssis/passing-variables-to-and-from-an-ssis-task/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply