I have a problem with a dts on sql7.
The dts runs every x hours and it worked find for months. Suddenly i
get the ffw error: "Unspecified error. Too many fields specified".
The error is displayed when started from enterprise manager,local

When I use the DTS wizard to import data into a SQL table only 3 out of 2050
records are imported and I get no error messages.  When I select the SQL
table of the same name with a $ on the end I can preview the first 100
records and the import seems to succeed and show 2050 ...

I need to create a flat file, with no delimiters between columns. I
tried using DTS, made a connection and a destination text file.  I see
no options to create the file without column delimiters , it asks for
the options: comma, tab,etc. The file has to be with no fixed column

I have a DTS that send mails through a DTSSendMailTask, so I need to
execute the Package as a Domain User.
The same package, before sends the email, executes a series of steps
that ussualy takes 4-5 hours to completion (the mail has the "job

I am writing a DTS package that gets executed remotely. The remote exectution
passes a value that populates the global variable of the main DTS package,
MainVar1.
There are several other variables in the package that are dependent on

How can I move a package from one server to another?

I am modifying a DTS package that had an existing ActiveX script.  When I
try to execute the DTS package, I get the following error when the package
tries to execute the ActiveX script:
"ActiveX scripting was not able to initialize the script engine"

I want to know if there is any way by which I can use a global variable
having data type other than string which can let me store more than 4000
characters ie more than allowed in a string.
It seems like string data type has length limitation (limited to 4000

I am trying to get into SSIS I am not a developer but a complete
newbie, I want and need to bring together data from different sources
for reporting services, score carding and anaysis services ect for our
company I am managing to move data from a to b ok however this does

sql2k sp3a
Dont know if "invert" is the right word, but the only one I could come up
with. I have a flat file that displays data like:
GEN_PROREGCTCTXT    CRZCODE    S_GENERATION

Trying to use Python 2.4.1 with the Win32 extensions (build 204) inside of an
ActiveX task.  When I step through the package running each step, the package
runs fine, even to the point of running the "message box" to see where the code
is stopping.

Any viable way of how to automatically re-execute the failed package.  That
is, to re-execute it three times then exit if failed again?
what steps and what will the code look like???
Thanks

Maybe I should ask this question in another group, but since I'm using it for
DTS... I don't know...
I'm copying data from DB2 and the existing packages use ODBC for DB2.  
Should I switch to OLE DB?  Is the performance better?

http://www.sqldts.com/default.aspx?104
This URL was extremely helpful, however I am having difficulties with the
example provided.
The example loops through the steps within the DTS Package to return the

I've been given a series of text files where all the fields are
delimted by a vertical bar, but each row takes up two rows in the text
file. So if I use any delimter like CR or LF etc., it treats each row
like two rows, since each row just finishes with a vertical bar and