Input File name to SSIS package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » 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:34 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 #837313

emily-1119612

Posted Monday, December 21, 2009 10:40 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 15, 2012 4:41 PM
Points: 214, Visits: 1,086

You can use the SET parameter with DTEXEC

http://msdn.microsoft.com/en-us/library/ms162810.aspx

xp_cmdshell will need to be enabled.

Create variables in your packages. The use expressions in your package so that your destination and sources refer to you variables. Your variables will need to have defaults. Get the package running manually. Then you can use DTEXEC and set your variables at run-time.

Post #837381

« Prev Topic | Next Topic »

Permissions