ssis package from one sytsem to another

Question

Post reply

ssis package from one sytsem to another

super48

SSCrazy

Points: 2682
More actions
February 26, 2014 at 3:17 am

#284007

hi i created on e simple ssis package i used xml configuration
and deployed it
now i moved the deployed .dtsx or package to another system and tried to edit the config file
but its showing error connection problem
while executing the package is searching the files in first computer where it deployed
cant i create .dtsx file and move it to other pc and execute it ?

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

How did you try to modify the config file?

Through the package configurations?

The location of the XML config file is hardcoded into the package, for example C:\Configs\MyConfigFile.dtsconfig.

On the other machine, the folder C:\Configs\ has to exist as well.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

super48 SSCrazy Points: 2682 More actions · Answer 2

actually i deployed the package and tried to change xml but there is no xml .config in c

how to move that one

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Copy paste should do it.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

super48 SSCrazy Points: 2682 More actions · Answer 4

i did same thing copied everything .

started the package edited the source in connection string in config file

while running no error is about source connection string

but destination connection login failed ...error is coming

but password is correct

i didn't taken destination connection string in XML configuration

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

What is the error?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Sushil Dwivedi SSC Eights! Points: 973 More actions · Answer 6

So it's clear.. it has not problem with your config because source connection is working fine.

Open the package and just do the test connection on destination connection manager with your password if you are using sql authendication

super48 SSCrazy Points: 2682 More actions · Answer 7

ya when opend the package

destination was showing error then

i edited it

after i started ssis package no error was their

but i dont want do do like that

..

i just want to run the .stsx file using config and it shoul run fine without oening the package

how to do that why destination connection showing error

Sushil Dwivedi SSC Eights! Points: 973 More actions · Answer 8

I don't think without modifying the package you could run it successfully.

Source connection: - Which you are passing from config that you supplied at run time.. it is working fine

Destination connection: - This connection value is there in package so without correcting it how will it correct at run time because destination connection is not there in package config.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 9

super48 (2/26/2014)
i didn't taken destination connection string in XML configuration

Any specific reason you did not include it in the configuration?

What is the protection level of the package?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

super48 SSCrazy Points: 2682 More actions · Answer 10

hi added destination conection ya everything is fine thank you all

super48 SSCrazy Points: 2682 More actions · Answer 11

thanks al i added destination config and i copied the ssis file its running fine