SSIS expression to SQL statement

I am trying to convert "Derived Columns" Expressions to SQL statements to be able to add and replace column values and names. I am having some issues in finding the correct help to understand nested formulas in SSIS. Formula i have in SSIS is, [...
more »

2017-11-30 08:11 (2) Answers

Use SSIS Foreach loop to loop multiple folders

I have one main folder, which contains 40+ folders. I have created an SSIS package that creates subfolders in 22 of the 40 folders. I want to use a Foreach Loop in my package to loop through only the 22 folders for my script to return the names and d...
more »

2017-11-29 19:11 (1) Answers

Money data type is overflowed

I am working on SSIS 2008. My task is to get the stats from a table in OLE BD and save it in a flat file. I am using two fields in a table saved in OLE DB the fields are in NVARCHAR data type. Amount and Currency are the two fields. I wanted the SU...
more »

2017-11-24 10:11 (2) Answers

Result of SSIS Merge Join

I have two data sources - Document and Customer and I want to join them, creating rows that that information both from documents and customer, having the customer_code as key. Finally, I get only 58 out of 30k results that I expected. Where is the...
more »

2017-11-12 19:11 (1) Answers

SSIS Excel File issue - Failure creating file

I have SSIS package that grabs excel file and load it to sql table .i get the following error when i run it. I have tried to make run on 64 bit to false. That did not work i also have installed 64 bit access driver engin . That did not help either....
more »

2017-11-09 22:11 (1) Answers

SSIS Date/Numeric Conversion from Flatfile

I have a Flat file which contains 2 columns . One is date time in this format 2017-11-06T11:16:08 AM GMT and Another Column Total value stored in this format £39.00. Destination is OLEDB (ms sql), Column 1 is Datetime and column 2 is Int ...
more »

2017-11-06 15:11 (1) Answers

Allow Data Push into an Azure SQL Database?

I'm relatively new to Azure and am having trouble finding what options are out there for connecting to an existing SQL database to push data into it. The situation is that we have an external client who needs to connect to our Azure SQL database to ...
more »

2017-10-24 17:10 (1) Answers

Efficient ETL Upsert in Redshift

I'm having performance issues with ETLing update-able tables from our OLTP environment to Redshift. Our basic workflow is the typical OLTP->S3->Redshift data flow. Let's say I want to ETL a table like this create table source_data ( id int primary k...
more »

2017-09-01 00:09 (1) Answers

SSIS Argument SQL for option Copy is not valid

I am trying to do a SSIS package deployment to SQL server 2008. I generated the manifest file but double clicking it didn't open the deployment wizard. I have tried to execute the dtutil command from the command prompt but getting an error Argument ...
more »

2017-08-11 18:08 (3) Answers

SSIS potential loss of data when converting

Working with SQL server 2014 ans SSIS, I am having the following issue in a data flow: Data Source: There was an error "The value could not be converted because of a potential loss of data.". This is the query: SELECT ISNULL(M.ActiveLED...
more »

2017-07-23 10:07 (1) Answers

SSIS Evaluate expression containing arithematic

I can't quite find the answer to this. How can I evaluate an expression that contains arithmetic in SSIS. Specifically within a variable's expression field or in the Execute SQL task -> SQL statement as expression. I have a user defined variable 'Wi...
more »

2017-07-07 17:07 (1) Answers

How to Make SSIS Package Fail When There's No Row

I have a very simple package of SQL Data Flow Task that executes a query and deletes the result. Is there a way to make my package fails when there's no result in the query? I try adding Execute SQL Task to get the result Count, but I'm not sure how...
more »

2017-07-01 02:07 (2) Answers

SSIS - Execute SQL Task - Foreach Loop Container

I try new project SSIS and i have an error Exception deserializing the package "The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events ...
more »

2017-06-30 07:06 (1) Answers

Convert month name to month number in SSIS

I have an input column "MonthName" which has values in the following string format 22-MAY-2017 02:29:33.00. I would like to convert this into Datetime data type in the destination table. For that the following conversion needs to be done 22-MAY-20...
more »

2017-06-19 17:06 (2) Answers

Flat File with multiple row delimiters

I am trying to import a group of Flat Files to SQL Server using SSIS. Everything is going fine, and the package execute normally, but while checking to imported data, it looks like the last column contains extra information from other rows. After c...
more »

2017-06-18 12:06 (1) Answers