Input File name to SSIS package:

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Input File name to SSIS package:

Input File name to SSIS package:

Rate Topic

Display Mode

Topic Options

Author

Message

Vasu-709835

Posted Monday, December 21, 2009 9:38 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 26, 2012 6:08 AM
Points: 23, Visits: 670

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?

Post #837319

Ted Zatopek

Posted Monday, December 21, 2009 1:09 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 27, 2012 2:34 PM
Points: 43, Visits: 735

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

Post #837513

Vasu-709835

Posted Tuesday, December 22, 2009 12:07 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 26, 2012 6:08 AM
Points: 23, Visits: 670

Thanks for reply,

But can we use variables and map file names to those variables or
any XML configuration?

Post #838133

bmr270

Posted Wednesday, December 30, 2009 12:08 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 3:30 PM
Points: 79, Visits: 354

I think, this link will help you.

http://www.simple-talk.com/sql/ssis/passing-variables-to-and-from-an-ssis-task/

Post #840515

« Prev Topic | Next Topic »

Permissions