SSIS Flat File Connector

[sirragu]

I would like to build a flat file connector programatically. It is so tedious entering manually. is there a way to do this? What format is it in? What is the name? Where is it stored?

Thanks in advance!

 

[mrdenny]

Connection objects are stored within the actual dtsx file. You can create a .NET script object to setup the connection object.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com