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 |
|
hizakemi
Starting Member
33 Posts |
 Posted - 2007-03-26 : 11:19:05
|
| All,What will be the painless way to import large fixed field text file that has more than 260 columns in sql table using dts pkg?Suggestions? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-26 : 12:41:23
|
| http://weblogs.sqlteam.com/mladenp/archive/2006/07/22/10742.aspx_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2007-06-01 : 13:49:40
|
| I ran:exec importFiles 'c:\Transfer\' , 'c:\Transfer\Archive\' , 'bcp*.txt', 'MergeBCPData'but got error:Cannot bulk load because the file "c:\Transfer\The system cannot find the file specified." could not be opened. Operating system error code 3(The system cannot find the path specified.). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-01 : 14:10:18
|
| The file needs to exist on the database server as that's where bulk insert runs.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-02 : 02:19:42
|
| or use universal pathexec importFiles '\\server_name\c$\Transfer\' , 'c:\Transfer\Archive\' , 'bcp*.txt', 'MergeBCPData'MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
IMPORT TEXT FILE