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 |
|
medtech26
Posting Yak Master
169 Posts |
 Posted - 2009-02-10 : 18:24:35
|
Hello,Google search bring many irrelevant results, it should not be complicated (at least wasn't in SQL 2K) but for some reason the DTS tool in 2005 (SQL Server 2005 Standard Ed.) is somewhat "diluted" so it became complicated (at least for me  ).In my case I have like 30 flat files, all of the definitions for them are in the db, including columns name, type and size etc.. DTS needs to run twice a year for those files so I would like to automatize the process. Any ideas how? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-10 : 20:41:44
|
| If you are using DTS use this:http://www.sqldts.com/246.aspxIf SSIS:Use ForEach Loop container to loop through all files and import. |
 |
|
|
medtech26
Posting Yak Master
169 Posts |
Posted - 2009-02-11 : 14:00:02
|
| On my server the only DTS available is "SQL Server Import and Export Wizard", I don't think the solution you provided works with this tool.Can I make the wizard mentioned above process multiple files? (it's not there by default.) or, is there and 3rd party tool that can accomplish that? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-11 : 14:04:57
|
| Don't you have DTS folders? What version,edition are you using? |
|
|
|
medtech26
Posting Yak Master
169 Posts |
Posted - 2009-02-11 : 14:35:46
|
Maybe I have DTS folders ... no idea what are those or where can I find them though.SQL Info.:Microsoft SQL Server Management Studio 9.00.3042.00Microsoft Analysis Services Client Tools 2005.090.3042.00Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 7.0.6001.18000Microsoft .NET Framework 2.0.50727.3053Operating System 6.0.6001 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-11 : 14:36:42
|
| Then you have SSIS. |
|
|
|
medtech26
Posting Yak Master
169 Posts |
Posted - 2009-02-11 : 14:42:15
|
quote:
Originally posted by sodeep
Then you have SSIS.
OK, missed that part in your initial response. Going to read about that ... Thanks |
|
|
|
|
|
|
Import multiple flat files (bulk) using DTS?