Microsoft SQL Server Integration Services (SSIS) Data Flow Transformations are a part of the SSIS ETL tool that enable programmers to perform data operations at row level with high performance, as the data is transformed as it passes through memory buffers.
5
votes
2answers
1k views
How to remove double quotes surrounding the text while importing a CSV file?
I have data which resembles the following:
"D.STEIN","DS","01","ALTRES","TTTTTTFFTT"
"D.STEIN","DS","01","APCASH","TTTTTTFFTT"
"D.STEIN","DS","01","APINH","TTTTTTFFTT"
...
5
votes
1answer
4k views
SSIS - dynamic column mappings
I am using SSIS to do data transformation from excel to OLEDB SQL. I have a set of sheets in a folder that i ll have to loop thru and insert the data in each of these sheets to a table. I have a ...
4
votes
4answers
3k views
How can I load a large flat file into a database table using SSIS?
I'm not sure how it works so I'm looking for the right solution. I think SSIS is the right way to go but I have never used it before
Scenario:
Every morning, I get a tab delimited file with 800K ...
4
votes
2answers
4k views
How do I convert the ErrorCode and ErrorColumn in SSIS to the error message and column name?
I am redirecting rows from a flat file source to a flat file destination. The default metadata in the redirected rows are:
The original flat file source row
The ErrorCode
The ErrorColumn
What I ...
4
votes
3answers
2k views
SSIS: from XML file to multiple tables
So I just started diggin SSIS today, so don't hate too much if there is something obvious I am missing.
So I have an XML file (from a third party)
<root>
<foo>
...
4
votes
1answer
730 views
Timeout error when i download files using FTP Task?
I have ssis package in that i used FTP Task.
When i Using FTP Task i download .csv file, i got operation timeout error.
The file size is 20 MB.
Please help me how to fix this.
Thanks
4
votes
1answer
249 views
SSIS Flat File Unpivot
I have a rather complex Flat File that I'm trying to parse using SSIS. The overall structure of the flat file is as follows:
CustomerName,
CustomerAddress,
CustomerContactInfo,
InvoiceDate1,
...
4
votes
1answer
562 views
DT_NTEXT columns in an SSIS package and Truncation Warnings
I have 2 questions :
1) I have a DT_NTEXT column whose value I'm extracting from the database and trying to feed into a Test column in Excel. I'm using a data conversion step in between to convert ...
3
votes
2answers
4k views
How do I format dd-mmm-yy values in flat file to smalldatetime during data import?
I have a flat file which is imported into SQL Server via an existing SSIS package. I need to make a change to the package to accommodate a new field in the flat file. The new field is a date field ...
3
votes
2answers
2k views
Is it possible to script data as Insert statements from within an SSIS package?
SQL Server 2008 provides the ability to script data as Insert statements using the Generate Scripts option in Management Studio. Is it possible to access the same functionality from within a SSIS ...
3
votes
2answers
556 views
SQL Query for appending rows into destination using SSIS
I have Created a SSIS Package for Importing the Records from One Table to Another table . It is Working Properly But In Source table records are increasing on regular basis . Therefore I am executing ...
3
votes
1answer
2k views
How to use the column names specified in Excel file's first row within a package?
Could anyone tell me how to change default column names (F1, F2, F3 etc..) when importing data from Excel source to an OLEDB destination in SSIS 2005.
Example: Data in my Excel spreadsheet looks as ...
3
votes
1answer
366 views
Ignore records with null field when copying from one table to another using SSIS
Is it possible in a SSIS to ignore records that have a null field? For example i want to copy data from one database table to another, however Table A has some rubbish data in it and has some fields ...
3
votes
2answers
780 views
SSIS vs Pentaho
Has anyone used both of these to provide a good comparison. I am doing a school project so the cost of SSIS isn't an issue as we already have the license for it.
Background on whats going on. I ...
3
votes
2answers
487 views
Excel Source is out of sync issue when loading data from a spreadsheet to database using SSIS
I want to load in information from an excel spreadsheet to the database using a SSIS package, and the package works fine when the spreadsheet doesn't change.
One of the requirements for this task is ...
