January 11, 2008 at 8:40 am
Still trying to convert our bank file into an SSIS package for automation.
If my flat file connection creates 4 columns and I indicate it via Bulk Insert Task to go to our temp table that has 9 columns, where is the option/task telling bulk insert how to map the flat file column to the correct table column?
January 11, 2008 at 9:12 am
I don't think you want to use the bulk insert task for this. The bulk insert task is expecting the source to have the same # of columns as the destination.
You can use a dataflow task and within the dataflow task you use a flat file source (uses your flat file connection) and an oledb destination (using your database connection). This allows you to map the source columns to the correct destination columns.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 11, 2008 at 9:16 am
Thanks jack I will remove the Bulk Insert Task from Control flow tab and go straight to data flow...
January 11, 2008 at 9:53 am
jack one more question.
if I have my Flat file as the source and OLE DB as destination, I want to clean the data in the DB table but when I try to add a Data conversion or Derived column to the OLE DB only the red (or error output) arrow is available.
In the Data flow can I have two workflows that do not connect? I think the answer is no but just wanted to make sure
Thanks again
January 11, 2008 at 10:03 am
In your dataflow your oledb piece is a destination thus it cannot be the source for a nother transform. In the COntrol Flow window add another dataflow task to follow your flat file load data flow dask and set up an oledb source that points to your newly loaded sql table and then an oledb destination where you want the data to go after cleaning it up.
You could also do any data cleanup in the Flat File load data flow by using another component or components to clean the data and insert into the final table.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 11, 2008 at 12:49 pm
Thanks Jack,
Did the data control steps after flat file then to export steps look good
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply