Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing the data source/destination of a package

Status
Not open for further replies.
collierd2

collierd2

MIS
Feb 26, 2007
61
0
0
DE
Hello

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
database)
I can't get this to change

Thanks for any help
 
Sort by date Sort by votes
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.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
117
tekpr00
tekpr00
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
120
botatun
botatun
Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
152
drlex
drlex
HoustonGuy
  • Locked
  • Question
CPU usage of a package using tables on another server
Replies
0
Views
52
HoustonGuy
HoustonGuy
arodri
  • Locked
  • Question
MSVisual Studio - DTSX Package creating new text file
Replies
0
Views
123
arodri
arodri

Part and Inventory Search

Sponsor

Back
Top