DTEXEC Error

Last Post 21 Dec 2007 10:21 AM by seera prince. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
seera prince
New Member
New Member

--
21 Dec 2007 09:36 AM
Iam trying to call my SSIS Package through Stored Procedure in command prompt. I am getting the following error. I could not find the issue. The error is
C:\>dtexec /server simsqlwds01 /sql "\SIMSQLWDS01\DTS Packages\DTS Packages\FCE_Costing_Load1\csv_Glob" /SET "\Package.Variables[p1].Properties[Value]";"C:\sacin\Spell_STG_to_CSV.csv"
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit

Error: 2007-12-21 13:51:32.60
Code: 0xC00470FE
Source: CSV to Spell STG DTS.Pipeline
Description: The product level is insufficient for component "Data Conversion" (1281).
End Error
Description: The product level is insufficient for component "Flat File Source" (270).
End Error

.. Please help if any one knows the solution for this type of error.

Thanks
seera prince
New Member
New Member

--
21 Dec 2007 09:53 AM
Iam currecntly on SQL 2005 SP2
seera prince
New Member
New Member

--
21 Dec 2007 10:21 AM
Srry Iam on 2005 SP1 only.....


Microsoft SQL Server 2005 - 9.00.3152.00 (X64) Mar 3 2007 05:22:48 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
seera prince
New Member
New Member

--
21 Dec 2007 10:26 AM
Is there any other way to call Dtsx package from Stored Procedure.....When we are calling Dtsx Package we need to pass a runtime variable (CSV file Path).

In that Dtsx Package , We will load the data from csv flat file to SQL Table.....but at runtime We need to pass the path of CSV file from Stored procedure...
SQLUSA
New Member
New Member

--
28 Feb 2008 11:16 PM
Try this:

dtexec /FILE “D:\REFRSH.dtsx” /Set "\package.variables[user::myvar].[Properties]value";"SVR"

or

dtexec /FILE “D:\REFRSH.dtsx” /Set "\package.variables[user::myvar].value";"SVR"

or

dtexec /FILE “D:\REFRSH.dtsx” /Set \package.variables[user::myvar].value;"SVR"


Let us know what happens.


Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/ssis/ The Best SSIS Training in the World!
SQLUSA
New Member
New Member

--
03 Mar 2008 03:39 PM
Great!


Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
BI Workshop NYC - March 17-20: http://www.sqlusa.com/order2005bitr...008031720/


You are not authorized to post a reply.

Acceptable Use Policy