I am new to creating ssis packages but I have one that I created via SQL management studio while importing data. What I would like to do is be able to pass the file name to the package and have it import that file instead of the way I have it now which is a specific file name. I am using SQL 2005 if that matters. Can someone explain how that gets done? preferably a way in which I can schedule it as a job.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.