Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avijit_mca
Posting Yak Master
109 Posts |
 Posted - 2013-07-10 : 11:01:45
|
i am able to run package using Vstudio but not able to run same pacage from cmd / bat file iff i mapped source / destination to txt/excel file.
if i not mapped txt/excel file then it is working.
Note :
Sql server :
version : 9.00.5000.00 SP4 Enterprise Edition
Microsoft SQL Server Integration Services Designer
Version 9.00.5000.00
Regards,
avijit |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-10 : 11:17:21
|
do you've providers for excel/txt files etc installed in the machine where you're trying to run it?
Also if you're using Dtexec, is your machine 64 bit? how are you calling Dtexec?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
|
 |
|
|
avijit_mca
Posting Yak Master
109 Posts |
Posted - 2013-07-10 : 11:21:10
|
quote:
Originally posted by visakh16
do you've providers for excel/txt files etc installed in the machine where you're trying to run it?
Also if you're using Dtexec, is your machine 64 bit? how are you calling Dtexec?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Regards,
avijit |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-10 : 13:00:32
|
sorry i didnt get answers yet
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
|
|
|
|
avijit_mca
Posting Yak Master
109 Posts |
Posted - 2013-07-10 : 14:44:07
|
running commAND :
dtexec.exe /f "\\pnch\Package2.dtsx".
Yes i used Flat file source as source connection.
Not : it is working if run from vstudio
Regards,
avijit |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
SSIS error - product level is insufficient