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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2007-12-16 : 13:35:48
|
| We have one dts package.The package is desinged for export the data from this server to flat file in .dat format. Like this i have 40 flat files, in this database i have 100 tables like each block transforms tasks has sql select statements with inner join of some other tables. This same package I have to create in ssis can I desing same like this? I can't find any dataflow, control flow.....or any task do u know how to create same like this in SSIS ? this is the project goal my client don't need to migrate that package from dts to ssis ........ he needs to create fresh with the same in ssis how can I create which task and control flow, dataflow I have to select in ssis I just create a small package with the same but only 2 files exported with select statment from pubs databse to test.dat file format, and then I migrate that package to ssis when I saw that package design its give me 2 control flow and each contraol flow has same desing with source(databse ) and destination (flat file in .DAT extention ). I need to design same like in SSIS Please discuss |
|
|
|
|
|
SSIS Package