June 29, 2015 at 7:09 am
Hello,
I am creating a package in SSIS 2008 by using Flat File Connection Manager to import data in tables from CSV Files.
For each time I am assigning column names and their data type in 'Flat File Connection Manger Editor' under 'Advanced' tab manually. I have to do same process with a big database having more than 80 tables having big list of columns. Assigning column names and their corresponding datatypes manually in 'Connection Manager Editor' is big job.
Is there is any other way to automate it by using tables in database or by using any csv file having format of each table 'column name - data type'.
To make this task much simpler.
Thanks
June 29, 2015 at 9:42 am
Did you try Suggest Types under the Advanced in the Flat File Connection Manager Editor?
Gerald Britton, Pluralsight courses
June 29, 2015 at 11:40 pm
Yes, I already used that 'Suggest type'.
But I need some way by which I can add column names and their data types from any CSV or tables from database rather than typing them manually each time in editor.
is it possible?
June 29, 2015 at 11:45 pm
The only thing that comes to mind that might allow that is BIML.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 30, 2015 at 12:00 am
I am not aware of BIML.
Could you please provide me more information or some links to understand BIML so that I can move further on the same.
Thanks
June 30, 2015 at 12:08 am
There is a Stairway devoted to it here[/url].
I'm not saying that it will be easy, by the way. But you may find something useful in there in terms of being able to automate the coding of packages ... even if you automate only the coding of the connection managers, it sounds like it could help.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 30, 2015 at 12:15 am
June 30, 2015 at 12:34 am
dfine (6/30/2015)
Please check this.
For someone with so many SSC points, I'm surprised that you don't know how to insert links.
The first link was the same as mine, and
here[/url] is a clickable version of the second.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply