Solved

dtsConfig file for 21 dtsx packages

Posted on 2014-01-20
2
296 Views
Last Modified: 2014-01-22
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
Comment
Question by:wdbates
2 Comments
 
LVL 15

Accepted Solution

by:
tim_cs earned 250 total points
ID: 39795217
Sounds like you're going to have a parent package kicking off Child ones.  So how about this?
0
 

Author Closing Comment

by:wdbates
ID: 39799973
Thanks for the link, that did the trick.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now