Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

execute package of a number of execute package tasks

 
   Database Forums (Home) -> DTS RSS
Next:  scripted find using local variable  
Author Message
jos

External


Since: May 01, 2007
Posts: 4



(Msg. 1) Posted: Sat Feb 16, 2008 12:31 pm
Post subject: execute package of a number of execute package tasks
Archived from groups: microsoft>public>sqlserver>dts (more info?)

In a project I have created 6 dtsx packages, all doing about the same thing:

sql task defines highest date in database and store in variable

script task to create an oracle sql statement based on the above date

dataflow task to
1.select from oracle, taking the select from variable above
2.do some data conversion (numeric --> int),
3.store in sql server table

run sp to add or update from tmp table to main table

Run one by one the packages execute perfectly.

In the same project I made a package "run all" and for each package I make a
execute package task.
When selecting execute task: This fails miserably, always at the third
package dataflow task, with the complaint that:

The external metadata column collection is out of synchronization (lot of
column names)

and

The column "ADD_ID_POSTAL_ADDRESS" needs to be added to the external
metadata column collection (a lot of these, one for each field).


The fields that I see in the progress tab are fields in the table of a
previous task within the package.

Any suggestions? Overlooking something?

Thank you

Jos

 >> Stay informed about: execute package of a number of execute package tasks 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Execute DTS package in SP - How would I execute DTS package in the SP? Thank you.

How to execute a DTS package from within Access 2000 - I want to know how to execute an existing SQL Server DTS package from within Microsoft Access 2000. Let's say I have an Access form with one control on it, a command button, and I want to execute the package when the button is clicked. Let's call my..

Execute SSIS Package - I re-created my DTS package in SQL Server 2005. I now execute the package using: [ Exec Master..xp_cmdshell 'DTExec /f C:\Data\packagename.dtsx' ] It is working fine however, is there another way of executing this package in SQL Server 2005 without..

user unable to execute a DTS Package - Hi, There is a package ' P' that is owned by a user "O"[Domain account with sysadmin/administrator rights]. Another user "U", who is not a sysadmin, but is db_owner of the DB that holds the Packages' objects, was not able to execut...

Execute Remote DTS-Package on different Server - Hello DTS discussion group, i'm going crazy with one maybe simple problem on executing DTS on SQLSERVER 2000. Situation: I have in my local environment a DTS-Package, which starts another DTS- Package. I used both dtsrun as command line task and the..
   Database Forums (Home) -> DTS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]