Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
on7june
Starting Member
41 Posts |
 Posted - 2007-12-03 : 09:02:25
|
| Hi all,I am creating SSIS packages which has flat files as data source and destination is SQLServer2005.I have successfully created packages for around 100 files. In future if the server is changed or/and the same flat file is moved to another location i cannot execute this created packages. I have to redo my work or i have to edit my packages which is a tedious job.Totally i am having around 750 files and each should have corresponding packages. Is there any better way to handle this changes. Ummm.... else i put it in another way. Is it possible to create a Front end application in which the user gives the Server name,user name,password and the physical location of the flat files and when submitting this, SSIS package has to be created for the flat file which the user has given.I browsed the net and found a link where they have given a way to create SSIS package using a program. Can anyone explain in detail about this.[url]http://lakshmik.blogspot.com/2005/05/how-to-programmatically-create-ssis.html[/url]Thanks in Advance.Sarvan |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-12-03 : 09:37:58
|
| If each transformation itself is pretty simple, I suggest you group them into package(s) that deals with multiple transformation tasks.Also, use variables to refer to file path/names, which is stored in a db table, as the sources. That way, you could just update the data in the table when you change your file path/name/location. |
 |
|
|
on7june
Starting Member
41 Posts |
Posted - 2007-12-03 : 09:51:03
|
| Since i am new to SSIS packages and SQL Server, I will first know what do u meant by transformations(I know its related to data flow but i need more knowledge in that.). I am not sure where to create those variables to refer my needs. Anyway thanks for your response.Sarvan |
|
|
|
on7june
Starting Member
41 Posts |
Posted - 2008-07-31 : 05:50:07
|
| Thanks a lot Hommer. As u suggested i have used variable to store the necessary details and created a configuration file which helps to change the details when needed.Sarvan |
|
|
|
|
|
|
Changes in packages