When I set the destination column, SQL craches.
Anybody can help me?

I have to create a report text file but in special format base on
information from a tables data.
The text file I need to create it in a particular folder with this format:
                                Report Date 5/24/2005

I have a requirement to populate a table from a file whose name changes every
time it is run. I can determine the file name using an ActiveX VBScript and
would like to then point the Text File Connection to it.  How would I do
this? Or is this the best way to do this?

I have some code that I am using to import a flat file into a bunch of
related tables.  I am trying to make it so that new records are added to the
related tables of a new value appears.  However, my code thinks that every
value is new and unique and creates a new entry for it.  ...

Please help:
I am trying to create a piple delimited text file through a DTS export which
consists of about 93 different fields.  However, there is one data field that
is populated from a list of options.  The user is allowed to choose one,

Every time I importing a text file the columns name change.
I can collect all the source columns in a string, when I call the pkg I pass
this string as GV.
In my Transformation I want to change change the name of the source columns.

I have a link server I'm trying to connect to in a DTS package.
I'm not sure what connection to use and how to set it up.
Any suggestions??

I am having probelm with Global Variables in my DTS Package.
Data Transform Task is defiend between 2 SQL Server. I have defined Global
variable in my Package and trying to pass variable value to SQL Statement
defined in  Data Transform Task.

Ok, I am getting this project pinned down, just need some more help.  My
SQL Task uses a simple query,
SELECT ExcelLink
FROM Cardholder

Can someone please tell me how/where is the log file when I am scheduling an
Export from one database to another. I would like to see the details of the
success or failure of that job.
Thank you.

I'm using SQL Enterprise Manager 8.0 and importing a text file into a SQL
table using a DTS package.
The text file has rows with 542 characters in each row and a CR LF (0D 0A)
at the end of each row in position 543. Using a Hex editor (Ultra-Edit) I was

As a beginner with DTS, I'd like to know if it's possible to export data
from a sqlserver with a package, but without predefined tablecolumns to
export. I want to build an export module from C# that exports columns the
user has selected (thus at runtime).

I'm running EM on my local box and sql server on a remote interne
accessed box.
How do I specify a file path for a DTS package to access files on th
remote box

I'm importing from Text (file) into a table that consists of 83 varchar
fields, then an Identity field.  The source file has no ID field, just CSV
data ( max 83 fields ).  In the Import Wizard as soon as I specify the field
delimiter ( comma ) the display shows that all ...

I am getting the following error:
"Too many columns found in the current row; non-whitespace characters were
found after the last defined column's data. "
It seems a few people (going by google/newsgroup searches) have encountered