Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

ssis package from one sytsem to another Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2014 3:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:08 AM
Points: 68, Visits: 409
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 ?
Post #1545291
Posted Wednesday, February 26, 2014 3:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 13,570, Visits: 10,448
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1545302
Posted Wednesday, February 26, 2014 4:09 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:08 AM
Points: 68, Visits: 409
actually i deployed the package and tried to change xml but there is no xml .config in c
how to move that one
Post #1545312
Posted Wednesday, February 26, 2014 4:15 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 13,570, Visits: 10,448
Copy paste should do it.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1545317
Posted Wednesday, February 26, 2014 6:22 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:08 AM
Points: 68, Visits: 409
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
Post #1545364
Posted Wednesday, February 26, 2014 6:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 13,570, Visits: 10,448
What is the error?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1545370
Posted Wednesday, February 26, 2014 7:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 4:09 AM
Points: 37, Visits: 142
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
Post #1545400
Posted Wednesday, February 26, 2014 9:51 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:08 AM
Points: 68, Visits: 409
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
Post #1545693
Posted Wednesday, February 26, 2014 10:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 4:09 AM
Points: 37, Visits: 142
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.
Post #1545696
Posted Wednesday, February 26, 2014 11:48 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 13,570, Visits: 10,448
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1545711
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse