Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

dtsConfig file for 21 dtsx packages

I will be importing about 20 CSV files nightly into a SQL 2008 database.  I would like to use a separate dtsx package for each file that I’m importing and these 20 dtsx are contained in a sequence container as I will have task to perform before and after loading these files.

My question is how to use the configuration file (dtsConfig) of the main dtsx package to point to the 20 separate dtsx packages?  I’m trying not to use 21 separate dtsConfig files as all of these csv files will be in the same folder and the destination database will also be the same for all.

I have attached an example of the package.
LoadTheData.docx
0
wdbates
Asked:
wdbates
1 Solution
 
tim_csCommented:
Sounds like you're going to have a parent package kicking off Child ones.  So how about this?
0
 
wdbatesAuthor Commented:
Thanks for the link, that did the trick.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now