| Author |
Topic |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2011-08-08 : 17:47:10
|
| Guys need help/advise, I created Package that has 12 data flows in all data flows I am using SCD Transformation. This package is in my local machine. I want to transfer this package in Client Machine. In client machine I am gonna use new source (same structure and table name) and new destination (same table and fields). I don’t want to create this package in client machine from scratch. I heard you can do through Configure the package. I tried but didn’t work out mean I didn’t success. I know how to configure package. I want to know what steps I should use on client machine. I am using sql server 2005. Thanks for help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-09 : 10:09:16
|
| you just need to configure connection manager values to xml configuration file and then sent the file and deploy it to correct location in server and change the corresponding values.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-08-09 : 10:41:48
|
| Visakh thanx for your reply, I want to know what steps i should follow in client machine to run my package without any labor. I know i have to change my config file in client machine, my questions is which values i have to change in xml file. Any advise would be great help. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-09 : 10:43:05
|
| do u have a generated xml config now?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-08-09 : 10:47:27
|
| Yes. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-09 : 10:53:40
|
| can you spot the values of your local server etc?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-08-09 : 11:01:13
|
| Yes. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-09 : 12:08:18
|
| just do a find and replace to replace the local server and databse names with names from your client server/db------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-08-09 : 12:12:33
|
| I can find out in my XML file "my source Server Name/db" How about my destination? Thanks for your help. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-09 : 12:17:19
|
| you need to change this XML with values from destination and move it under same path in destination server (create it if not existing already)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-08-09 : 13:14:18
|
| or run the migration wizard after you build your SSIS packageIf you don't have the passion to help people, you have no passion |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-09 : 13:25:55
|
quote:
Originally posted by yosiasz
or run the migration wizard after you build your SSIS packageIf you don't have the passion to help people, you have no passion
Only if you create the deployment utility rite?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-08-09 : 13:30:59
|
| Yosiasz you are talking about Project==>Migrate DTS 2000 Package ? |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-08-09 : 13:47:01
|
No not migrate wow don't do that!! the deployment utility. it is a life saver I highly suggest going that route. On your SSIS package's menu go to Project then select your project Properties Set CreateDeploymentUtility = TrueChoose a folder where you want to dump the deployment manifesto: bin\Deployment is fineBuild your SSISGo to your bin\Deployment folder and double click the deployment xml a wizard appears. If you have set the xml configuration properly the wizard will prompt you for the values that need to change. If you have any FTP connections on your SSIS those are tricky.This is what I do and it has proven to be very helpful. Many ways to skin the catIf you don't have the passion to help people, you have no passion |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-08-09 : 14:15:15
|
| Here i am missing something,Is it possible i will email you with screen shot my steps to find out where i am wrong, It would be big help for me? |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-08-09 : 14:32:07
|
| no problem.If you don't have the passion to help people, you have no passion |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-08-09 : 14:59:59
|
| In your profile i am not able to see your email so i can email you. Send email button only alow me to paste character but i have screen shot to show you. If you feel comfertable provide me your email add. Thanks. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-08-09 : 15:02:08
|
| check your email. I just sent you an email.If you don't have the passion to help people, you have no passion |
|
|
|
|
Transfer Package from One location to Other Help