Hello to all,
I am trying to learn the DTS one step at a time. I want to execute a DTS
package using .Net. I got the idea from one of the posts here with the
sub: Executing a DTS Package from VB.NET forms . It works fine when all the

I have been reading all day trying to figure out this one and I can't
find out why I am having this issue....
I have created a DTS package that export a SQL statement to Excel. The
package runs perfectly in Entreprise Manager, however, when I run the

I am trying to issue an INSERT statement from within DTS to Teradata. I want
to use "Parameters" as value in the statement. While doing this in Oracle it
was easy, I was passing question mark "?" in the VALUES.
Don't know how to do that with Teradata. Please help.

I need to update a table in the oracle with data that came from the SQL
Server but I cant delete all the lines in the oracle I need to check if
the line doenst exist in the destination table and then append this
line.

I am trying to build an automated process that would allow someone to upload
a CSV file via FTP to a specific folder and then the DTS package would do
it's thing every hour and import the information then delete the CSV file.
All of this is not a problem except that the first 9 ...

I am getting an error "[DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied." when I try and execute a DTS
package from VB.NET  (forms) using the method LoadFromSQLServer.
I am trying to execute a package from a remote SQL Server. The package

I am having problems in DTS packages that runs nightly. It is
always the same Error at the same 'Execute SQL Task'. The ohter Tasks
in
the same DTS packages works fine with the same OLE connection.

We have been getting a strange error with this particuar package that we've been running a scheduled job, from Integration Services and havn't been able to figure it out.  It works fine when running from Visual Studio but not so much when we are scheduling it.  Below is all of ...

Hi, I need help accomplishing a task and I'm not sure how to go about it
but I do know that I want to do it using DTS.
I have a text file, A, with a list of id's and I'm supposed to execute a
SELECT query on each id and send the data to another text file, B. I'm

I don't have accesss to DTSRUN.  Can someone tell me if its /L
(log_file_name) argument will accept a UNC path?  Thanks.

I've been having a problem with all of the packages I create. I create
them in BIDS on my local machine (which is running SSIS, as I
discovered that was needed for the packages to run properly on the
server). I then create an XML config file and deploy them to the file

I have a 32 bit SQL Server 2000 installation that is current on service
packs that is installed on a 64 bit version of Windows 2003 (this actually
works ok). It's not mine, but I have to deal with it.
There are a few DTS packages I need to transpose into T-SQL that read from

I need to import into SQL dbf files. In SQL2KDTS there was an option for
this, but in SSIS I do not see an option for dbf files. I tried a few that I
thought MIGHT be the instance but nothing has worked so far. What file type
do I use for this now?

I am looking for some tutorial on SSIS, beside the one from MS online
tutorial.
Can you help?
thanks

I am trying to debug a script task in an event, is this possible?  I get a
window that opens and contains the script task from the control flow but that
is all I ever see.  Any help would be appreciated.  I am not sure what
additional info is needed to help diagnose this, but I ...