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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-01 : 23:12:43
|
| Alex writes "Is there any way to create import specifications for fixed-length file "on the fly"-programmaticly?(DTS or bcp)In another words, I have specifications for fixed file i.e. each field's start position, length,end position and data type. I can write this info into anything using code. What I don't know is how to access this properties of DTS package at run-time.Any ideas?" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-02 : 00:11:05
|
| Hi thereYou have a few options, you can code against DTS. Or, (and this is probably the way to go) look into format files for BCP. Books online has a bunch of stuff there.Hope that helpsDamian |
 |
|
|
harishon
Starting Member
3 Posts |
Posted - 2002-01-03 : 20:10:24
|
| Thanks to everyone who responded, but it seems that I found answer my self. bcp is ok, but not very suitable. What I found is ScriptPkg utility which comes with MS SQL 7. It's VB app that scripts your package. So you can make a sample package, script it with this app and modify resulting file(VB code) to your liking and then run to make actual desired package. This utility may be found on SQL 7 CD at\Mssql7\DevTools\Samples\DTS\DTSDesigner.exe . Extract it and look in folder designer. |
|
|
|
|
|
|
import/export