Tag: ssis

SSIS Transfer Database SMO Timeout

I have to copy a few databases from SQL Server 2008 R2 to our new server which running SQL Server 2016. I am trying to do this inside SSIS project, using Transfer Database Task with ‘Online’ mode as I really don’t want to put offline my DBs. Each database has size > 15 GB. Unfortunately […]

SSIS 2008 R2: Export “0.0000” to Flat File Destination

I have a column called as item_price with data type DECIMAL(12,4). Records: item_price ——– 0.0000 0.1201 0.0001 0.1000 1.0230 I want to export the same values into the flat file using SSIS package: My try: Added tool Derived Column with the following expression: item_price == 0.0000 ? “0” : (DT_WSTR,50)item_price Output: item_price ———– .0000 Added […]

SSIS OBDC(Informix) SQL SERVER 2014 PASSWORDS

I have several developments with the following workflow OBDC(Avaya – Informix Table) —> SSIS(ETL) Connection String ,Query —> SQL Server 2014 Table For the ssis package i use connection strings , the policies on my company makes me reset my Avaya password every 28 days , and i’ve got up to 50 packages , the […]

Error 0xc0202009 while importing a text file to SQL Server using Microsoft SQL Server Management Studio 17

I’m trying to import a text file of 200k rows into sql server using sql server management studio 17. but its showing the following error: Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: “Microsoft OLE DB Provider […]

Bulk upload million records to DB from Excel sheet

I have a task where user upload excel file having million records from UI and I need to validate the data and if everything is correct, it will upload all million records at single shot(bulk upload) to SQL DB. I have been analyzing the approach how it has to be done. I get only 2 […]

SSIS Package Error: To run a SSIS package outside of SQL Server Data Tools

I am getting below exception while executing package with “Script Task” from my .NET application, if I remove script task from package then it’s running fine. To run a SSIS package outside of SQL Server Data Tools you must install Script Task of Integration Services or higher. When I am executing package with script task […]

special data loading logic in ssis

I have a dump file that i receive everyday and i wonder how to get it load through ssis and script task in sql server database. the format of the dump is mentioned below, from These should be only two record rows, whereas in file i need to write a parser which can actually buffer […]

SSIS Excel Validation Failed Error

I am loading excel to sql server database table. I am facing the below error on excel source validation failed. Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Data Flow Task: There were errors during task validation. Warning: 0x80019002 at Infinite loop: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The […]

SSIS script tasks can't compile because of missing dlls

We rolled out SSIS-Packages to our customers, that include script tasks, which reference 5 dll files in the folder: C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework.NETFramework \v4.0 On the target server, there doesnt seem to bee .dll files in this folder, only xml files. Therefore the script tasks can not compile. Would it suffice to add these missing […]

SSIS job fails when run remotely thru ssms, but runs fine on SQL Server

Installed SQL Server 2016 on a dev box, with SSIS. Have a package that loops thru a directory and validates XML files. The job runs fine on the SQL Server from the Integration Services Catalog and from SQL Server Agent, when executed there. Also runs fine in the local developers PC’s. The issue comes in […]

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