Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Changing the data source/destination of a package

Changing the data source/destination of a package

Changing the data source/destination of a package


I have a package that transforms some data into a table
(test, will eventually do a number of these transfers)

It has a dynamic properties task along with a source and destination OLE DB Connection

There's a transform data task between the source and destination servers

I have created a package that runs this package and passes through the source and destination database/server

Problem is, it just does not work
It runs how it was originally created and ignores the parameters passed through

Does anybody know why as this has been puzzling me for some time now - it's getting a bit frustrating!!

I don't know if this is the issue - the destination table shows a fully qualified table name (including original
I can't get this to change

Thanks for any help

RE: Changing the data source/destination of a package

A package [call it pkgA] that runs another package [pkgB] actually runs a version of the other package.  When you update pkgB the version is not updated in pkgA, the calling package.

You must change the version yourself in the Properties dialog for pkgA.  Open the Properties dialog for the Execute Package Task and on the General tab there is an item, Package Name. Click the button next to that field to list all the packages.  click the plus sign by the name of pkgB and you will see a list of dates for the versions of pkgB. Select the latest version and save.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close