Friday, February 24, 2012

import a dynamic file name into a known table

How would I import a dynamic file name into a known table?

I have the file name in a variable. So what object in SSIS do I use to do this.

Thanks

If you just want to insert file name into table, why do you need SSIS? You can just use an insert command which takes the file name variable as parameter.|||

I have inherited a SSIS package that does massive amounts of importing, so I am trying to stay with the way it eas done.

Out of curiosity how woul I do what you said? How would I do it in SSIS?

No comments:

Post a Comment