All geek questions in one place

In SSIS, when defining a fixed flat connection to a file with flat files, is there a way to programmatically define columns?

I could not play with my four year old yesterday. Why don't you ask?

Since I had a file with a fixed length of 150 columns that I need to configure in SSIS to import into the SQL server database.

I know how to do this, but I am not able to define the columns programmatically, forcing me to bully. This is worse than watching the repetitions of American Idol.

In the "Flat File Connection Manager" Manager, I set the format to "Ragged right" to check "Column names in the first row of data."

Then on the column tab there is an interface in which you define the columns.

I have column definitions in excel distribution sheet. I know the column names and exact length.

But why in the name of Zeus do I need to manually click on this stupid little ruler 150 times

I have to be able to do this script.

I mean sitting, clicking on the columns in absolute mind-blowing. It took me three hours to complete an hour, because every three columns or so the editor took me back to the beginning of the row, forcing me to scroll back to where I was (argh !!!!).

I even opened the SSIS package.dtsx file to see if I can edit it outside of Visual Studio, however the GUID value next to the DTSID property muffled this brilliant idea.

So, my dear StackOverFlow community, is there a way to define a software connection with flat files with a fixed length and thereby skip the pleasure of manually clicking 150 columns?

+6
source share
1 answer

Yes: http://blogs.msdn.com/b/mattm/archive/2008/12/30/samples-for-creating-ssis-packages-programmatically.aspx

Usually you open an existing (template) package through .NET using the Microsoft.SqlServer.Dts classes. *, add the connection manager and columns, and then save the package for further configuration manually.

+1
source

Source: https://habr.com/ru/post/920604/

More articles:


All Articles