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 |
|
dabu1
Starting Member
1 Post |
 Posted - 2007-02-07 : 05:29:09
|
| Hi,i need to import a fixed with text file into several tables in SQL 2005.The file contains records that should go inte different tables and i would like to know the order of the design..I also get some errors when trying to convert the text to unicode, even with the derviced column data flow task..?flat file source -> Data conversation/Derived column -> aggregate?I have not found the way of importing the file into several different tables in the DB.Thanks for suggestions..Regards,Daniel |
|
|
wali
Starting Member
7 Posts |
Posted - 2007-02-08 : 11:48:46
|
| I'm not sure if this is what you are asking for , but would it not be possible to use a SQL query Task ..Which would probably use a query ....SELECT * from Filename where colum = 'xxx' and then output the result to the table. |
 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-02-13 : 04:51:03
|
| Have you looked at the Conditional Split data flow task?Mark |
|
|
|
|
|
|
Importing a flat file in SSIS