SSIS error - product level is insufficient

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.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

SSIS error - product level is insufficient

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

Posted - 2013-07-11 : 01:00:53

quote:
Originally posted by avijit_mca

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

oh ok dtexec

check this and see if it helps

http://visakhm.blogspot.com/2011/12/dtexec-issues-running-ssis-packages-in.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources