June 29, 2010 at 2:50 pm
We need to create a load package and incorporate the field names in the mapping steps within SSIS. There are many load files with no headers, one file for each dest table. THank for any ideas or steps.
June 29, 2010 at 2:58 pm
The first thing that comes to mind is using the Import/Export wizard and saving the package which you can edit later.
CEWII
June 29, 2010 at 3:02 pm
The manual edits are what we are trying to minimize, was thinking there might be some way to loop thru the table.fields, but if so, is there equivalent way to write to an equivalent SSIS component/object(s) once the field information is acquired. Hope that makes sense.
June 29, 2010 at 3:13 pm
RandyO (6/29/2010)
The manual edits are what we are trying to minimize, was thinking there might be some way to loop thru the table.fields, but if so, is there equivalent way to write to an equivalent SSIS component/object(s) once the field information is acquired. Hope that makes sense.
There is no way using any of the out-of-the-box components to do that within a package. HOWEVER, that doesn't mean it isn't possible.
I suggested the import/export wizard because it does much of the work for you and can generate a package that you can edit further, mileage may vary..
Using the SSIS object model, create a package programatically, at this point in time, I'd rather get water-boarded, but I digress. This method is painful for a competent developer, torture for about anyone else.
There is a company called CozyRoc (who I was just mentioning to in another post, that I recommend looking at his stuff periodically) who makes a component that you might find fits your needs, if I remember correctly it is called Data-Flow Plus.
CEWII
June 29, 2010 at 3:27 pm
Thank you. We'll look into this further. It at least will help us move in the right direction.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply