Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Input File name to SSIS package Expand / Collapse
Author
Message
Posted Monday, December 21, 2009 9:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, December 21, 2009 10:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC 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 »

Add to briefcase

Permissions Expand / Collapse