View Complete Post
I am trying to migrate our processing from command line based scripts and foxpro to SQL so IÃÂ need to run the SSIS packages using dtexec. I copied the dtexec file and a few dll's that are missing to our production servers but i cant execute the packages. I dont want to install the full client tools (particularly managment/business inteligence studio) on our production servers due to the overhead and limited system disk space.
Can somebody tell me what the minimum install would be so I would be able to run SSIS packages using the dtexec or dtexecui tools? I would also like to install some of the other command line client tools like osql etc.
I am using SSIS 2008, I set a varaible @t1 to data type CHAR and set the value to
Y next I used an Execute SQL Task with an ADO.NET connection to SQL 2008 R2 database to insert this the value of @t1 into a test table with only 1 column of data type NCHAR(1):
insert into test1
On the Parameter Mapping section of this task I put the Data Type as String and initially set the Parameter size to
The only problem is it tries to insert a 2 character numeric value into the SQL table. If I set the value of @t1 to N the parameter mapping seems to convert this to
78, when I set the value of @t1 to Y the parameter mapping converts this to
89 it looks like it converts the character to an ASCII code.
Is this meant to be the intended behaviour, as all I wanted to do was insert the actual character into the destination column and not the ASCII code?
When i am trying to execute the SSIS Package in BIDS, it works fine. When I schedule the same package as job in SQL Server Agent it gives the following error.
Here is the complete log information:
Log Job History (ssis)
Step ID 1
Job Name ssis
Step Name ssis
Sql Severity 0
Sql Message ID 0
Operator Net sent
Retries Attempted 0
Executed as user: NT AUTHORITY\NETWORK SERVICE. The package could not be found. The step failed.
i tried to run the job with proxy accounts also but it didnt work for me. Please help me.
I am using SSIS Import and export Wizar to load data from Excel file, I have set the datatype as "nvarchar(max); those data are not biger than 1000 bits but was failed to transfer as the error says:
[Source - TreatmentPlans$ ] Error: The "output column "SchoolPlan" (57)" failed because truncation occurred, and the truncation row disposition on "output column "SchoolPlan" (57)" specifies failure on truncation. A truncation error occurred on the specified
object of the specified component.
Hi all members.
I need to ask for the following code. I need to convert the variable into a string.
"Select Distinct convert (int ,A.CustomerCategory) as AccountReceivableCategoryID, convert (varchar(40), B.Text) as AccountReceivableCategoryNameE
from Inkunde A , inpara B
where A.CustomerCategory= B.SearchItem
and B.Language1 = 'EN'
and B.ParameterName = 'CATEGORY'
and A.CustomerCategory = (DT_STR,200,1252) "+ @[User::CategoryID] +"
Order By A.CustomerCategory"
Kindly any member let me know, How to correctly use the Type Cast fucntion in variables
Thanks and Best Regards,
I have developed a dtsx package to load data from xml load table into a dozen of flat tables. I found the SSIS is running slow (almost 10 times slower) under Execute Package Utility than running under visual studio IDE.
Does anyone have same experience?