August 21, 2008 at 3:07 pm
OK, I'm trying to copy tables from one database to another database using a DTSX package I created. The package works fine on the computer I created it on, but here's where's where the problem lies:
Parts of the DTSX package point to %userprofile% so when I try and run that DTSX package on another server, it fails. You can't use variable subsitution in a DTSX package (not that I can tell anyways) and I could try using a more standardized path to the package since that path will exist on both the server I created the package on and the server I want to update, but there are temporary files and XML configuration files that, you guess it, point to %userprofile%.
Any help would be appreciated.
August 22, 2008 at 6:31 am
Could you stick a variable in the package that you read from a configuration file that sets where you are running the package and pick the location based on that variable?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 22, 2008 at 6:39 am
I've tried editing the DTS package with notepad to subsitute windows variables like %cd% and it fails miserably. I may have to script the database to CSV file and then script it back into the database I want to re-populate.
August 22, 2008 at 7:11 am
Well, I manually edited the DTSX package and removed all paths and just left the file names, which forces it to use %CD%. I had to copy all the temp files into the folder that I ran the package with on the original server. It works now, but I'll try it on a couple more VMWares just to make sure.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply