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:38 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 #837319
Posted Monday, December 21, 2009 1:09 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Tuesday, December 22, 2009 12:07 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, December 30, 2009 12:08 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 11:38 AM
Points: 80, Visits: 357
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 »

Add to briefcase

Permissions Expand / Collapse