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

how to run ssis package on command prompt with configuration Expand / Collapse
Author
Message
Posted Sunday, August 25, 2013 4:28 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 9:44 PM
Points: 888, Visits: 671
i have created one ssis with configuration .

i have run on BIDS that time it is executed scucessfully.

whenever i had run through command prompt that time it was failed.

Configuration type: xml

Variable type:environment variable.

i have given path in command prompt

c:\ dtexec.exe /F "D:\SSIS\first.dtsx " /conf "D:\conf.DtsConfig"
Post #1488198
Posted Sunday, August 25, 2013 1:12 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:55 PM
Points: 13,253, Visits: 11,033
What has the environment variable to do with the command line? You specify a dtsconfig file directly.
What is the error that you get?




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 #1488225
Posted Monday, August 26, 2013 9:05 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 9:44 PM
Points: 888, Visits: 671
how i will use environment variable in command prompt..

Post #1488533
Posted Tuesday, August 27, 2013 1:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:55 PM
Points: 13,253, Visits: 11,033
You need to configure that in the package itself, not in the command prompt.
The package will automaticallly retrieve the value from the environment variable and search for the corresponding XML file.




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 #1488580
Posted Tuesday, August 27, 2013 1:25 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 9:44 PM
Points: 888, Visits: 671
i am saying how i mapped configuration in ssis package.
when ever i had run that package in bids it is excuting suceessfully.
when ever i will run through command prompt that time it is not working.
that why i am asking how to excute this type ssis package through command prompt.
Post #1488585
Posted Tuesday, August 27, 2013 1:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:55 PM
Points: 13,253, Visits: 11,033
DTEXEC /f "c:\myPackage.dtsx"

What is the error that you get?




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 #1488587
Posted Tuesday, August 27, 2013 3:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 9:44 PM
Points: 888, Visits: 671
whev ever i had run package through command prompt below sitution.
when ever i have created connection in project level
that time package was failed.

when ever i have created connection in package level
that time package was excuted success.

how i will resolve this error.
i am using bids(2012).
Post #1488641
Posted Tuesday, August 27, 2013 3:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:55 PM
Points: 13,253, Visits: 11,033
subbareddy542 (8/27/2013)
whev ever i had run package through command prompt below sitution.
when ever i have created connection in project level
that time package was failed.

when ever i have created connection in package level
that time package was excuted success.

how i will resolve this error.
i am using bids(2012).


You cannot use configurations and the project deployment model at the same time.
Which deployment model are you using?




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 #1488647
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse