Tag: ssis

SSIS Execute SQL Stored Procedure output parameter type mismatch

I’m getting the following error on an SSIS package: [Execute SQL Task] Error: Executing the query “EXEC [spGetFileId] @zFileName, @Id” failed with the following error: “The type of the value being assigned to variable “User::FileId” differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables […]

Performance in an SSIS package with asynchronous component

Hi everyone as I already posted here : I face some problems excuting my SSIS packages, actually they take huge time. Due to a lot of constraints I’m trying to resolve one to one ! I start with the query it takes more than three hours to extract 720 000 rows her’s it: Select –11 […]

SSIS error with xp_cmdshell

I’m new to a project and created a new SSIS package. When I execute the package by double-clicking it, it works. When I type into the shell: dtexec /F “D:\path\to\my\ssis\package\mypackage.dtsx” /SET \Package.Variables[User::MyVariable].Properties[Value];”10″ It works also. But when I run my Stored Procedure which has the following code: EXEC xp_cmdshell ‘dtexec /F “D:\path\to\my\ssis\package\mypackage.dtsx” /SET \Package.Variables[User::MyVariable].Properties[Value];”10″‘ It […]

How to change a Date Column into two separate columns, MONTH and YEAR

I am importing a spreadsheet that has a date column labeled StartDate (01/01/2000) I need to split it into two columns one that is Month the other that is Year. The Month has to be the Month Name (Jan, Feb, etc) the other is a simple 4 digit year. I want to do this through […]

Equivalent SSIS expression

I am unable to convert the following SQL to a corresponding SSIS expression and cast it to DATE format SUBSTRING(A.FILENAME,13,2)+’-‘+SUBSTRING(A.FILENAME,15,2)+’-‘+SUBSTRING(A.FILENAME,17,4) This is the best I could get DT_DATE(SUBSTRING(@[User::V_LoadFileName],13,2)+’-‘+SUBSTRING(@[User::V_LoadFileName],15,2)+”+SUBSTRING(@[User::V_LoadFileName],17,4)) Any suggestions?

SSIS – Intermittent error “Conversion failed because the data value overflowed the specified type.”

I have an SSIS package which intermittently fails with a handful of errors, the two most informative of which are: DFT_PlaySummary SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0” Hresult: 0x80004005 Description: “Invalid date format”. An OLE […]

Runtime error in script task

We have a fully running database server, say serverA, whose data are refreshed daily. We want to duplicate this database on a different server, says serverB, so that we have a test environment. The databases has been restored to serverB. Like serverA, we want serverB’s data to be refreshed daily also, so the tests we […]

Calling local SSIS package from C# console application

I’m trying to run a local SSIS package from a C# console application. I’ve built both the package and the application using .Net 4.5.1 in VisualStudio 2012. When I say “local” I mean the SSIS package hasn’t been deployed to a SQL Server; I’m just trying to call the .dtsx file from the file system. […]

Why i can not find value is numeric conditional in dqs domain rule?

I’m beginner in Sql server Data quality services and for that purpose read this tutorial from microsoft MSDN site: Create a Domain Rule But in the my data quality can not find value is numeric condition in domain build rule,what happen?how can i solve that problem?thanks for all.

Record only certain rows of a text file in SSIS

I’m having a hard time trying to do a simple loading of data from a flat file to a database. The problem is that there are bad rows or at least rows that are not formatted as data in that text file. Sample.txt: Stackoverflow School at Philippines Record: 100101 Date: 6/20/2014 Name: Age: About: ——————– […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.