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

SSIS - export to excel through open XML

Earlier we have used Microsoft OLEDB JetProvider in SSIS package. After recent update from Microsoft, now we are facing issues with SSIS package. So we have decide to export data to excel using open XML. What should be the best approach for implement...
more »

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

Import a Multi-format Delimited File

I need to import a file into several database tables. The file contains several simultaneous formats, like this: 901 902|1|Id|Name|Age 902|2|Id|Region|Address 902|3|Id|ProductName|ProductType|Price 903 1||Adam Sandler|40 1||Phil Collins|50 1||Fred ...
more »

2017-10-30 22:10 (2) Answers

SSIS Foreach loop error on CSV files

Right, so I have a foreach loop with a data flow inside going through a group of files with all the exact same format. This changes a few things with a derived column which is all getting dumped into a SQL Server Database which will become my staging...
more »

2017-10-18 15:10 (1) Answers

SSIS Rearrange Full Name In Same Column

I have an excel file to load into my database, I'd like to rearrange the name field to this FIRSTNAME M LASTNAME instead of the format it's in now which is LASTNAME, FIRSTNAME M. to keep it consistent with a previous load I ...
more »

2017-08-16 14:08 (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