SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS error - product level is insufficient
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

avijit_mca
Posting Yak Master

India
109 Posts

Posted - 07/10/2013 :  11:01:45  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 07/10/2013 :  11:17:21  Show Profile  Reply with Quote
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
Go to Top of Page

avijit_mca
Posting Yak Master

India
109 Posts

Posted - 07/10/2013 :  11:21:10  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 07/10/2013 :  13:00:32  Show Profile  Reply with Quote
sorry i didnt get answers yet

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

avijit_mca
Posting Yak Master

India
109 Posts

Posted - 07/10/2013 :  14:44:07  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 07/11/2013 :  01:00:53  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000