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 |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2009-10-16 : 13:44:50
|
| Hi Guys,I need suggestion on how to create a SSIS package for an assignment... I have not worked on SSIS before and the company wants me to create SSIS for this...We will be getting say 9 files from a vendor everyday... There will be workflow created for each file. When we get each file separate work flow will be triggered... application created in dot net will move the fiel from ftp location to source location, unzip and decrypt and also kick start the SSIS package(s) that I will create for the staging and loading. Since the workflow will run separately for each file what do you suggest guys? Should I create separate SSIS package for each file or can we do that through one SSIS package? Any suggestion is appreciated..Thanks! |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-17 : 05:33:10
|
| Of what file type are the nine files?All text/csv? Excel? Or a combination?Do the files have the exact same format/fields? |
 |
|
|
GhantaBro
Posting Yak Master
215 Posts |
Posted - 2009-10-19 : 10:44:41
|
quote:
Originally posted by YellowBug
Of what file type are the nine files?All text/csv? Excel? Or a combination?Do the files have the exact same format/fields?
All of the files are fixed width flat files... they will have different layout... for flat file do you think bulk insert task with format file is better? |
|
|
|
|
|
|
SSIS Process for Multiple Files