Does everyone know if there is command line to build a SSIS project
equvilent to the build menu in the visual studio?
Thanks,

I received this error when processing SSIS Package.  
Error: A deadlock was detected while trying to lock variables
"User::LoopCount" for read/write access. A lock cannot be acquired after 16
attempts. The locks timed out.

If I assign variable "LoopCount" in the ReadWriteVariables property of a
Script Task, it should carry over to the Loop Container Scope afterwards
right?  
Here are the steps I am using.

I have folder called TEST and is located in C drive.  Every month, a new file
with the name IMMYY.txt will be put in there (MM---Month, YY---year).  How
can i create a SSIS package to check to see whether there is any new file in
TEST folder and, if there is, insert into the ...

under sql server 2000, do you know how I can access via vbscript to the dts
code and make programmatically some changes ? what are the usefull api's  ?
for example, I want to change database properties
of course, I can write the  dts the correct way in order to handle

I'm getting an environment ready to test SQL 2000 DTS packages running in
SQL 2005 (under legacy..DTS).  I will be calling these from VB code attached
to an ASP.NET 2.0 app.  Before investing too much time...
1) Is it possible to call DTS packages from .NET using SQL 2005?

i am writing DTS in sql server 2000. i have to write the delay, such as
delay for 1 minutes before taking to next step. i have to use WScript.sleep
(60000) to do the delay, but it prompted the error.
Object required: 'Wscript'

Just put on a project which I need to learn some ssis.  Could someone
provide an outline on how to approach this task.
1)In a sql table we have an xml doc stored in column of datatype "text"
2)I need to query the xml in the text col to pull out a value

I had several jobs scheduled to copy databases from a live instance to a
development instance both running on the same server.  On installing SP2, the
jobs now fail with the error below.   The packages referenced by the jobs are
executed successfully using Visual Studio or the ...

I have a situation where I have a remote system that I need a File from.
I have created a database link from the oracle system to sql server.
When oracle generates the file it then writes a row to a indicatator table.
I need to then execute a dts job to ftp the file from the remote ...

I have a SSIS package that loads the contents of a worksheet in an
Excel document into a table.
Simple process;
1) Extract from Excel using Excel Connection Manager

Can anyone tell me if there is any significant difference in speed using drop
and recreate table vrs delete rows in existing table on a table with a large
number of records?

I am running a stored procedure as a job step and in the stored
procedure  I use return to pass one of several possible values when
there is an error in processing (not an system error) so that the job
step will fail.  However, even when I return a non-zero value using

Let me begin by saying my script runs perfectly from Windows.  It fails
within an ActiveX task on DTS run interactively from my workstation via
Enterprise Manager:
Set objConnection = CreateObject("ADODB.Connection")

  I'm  wondering if it's possible to somehow dynamically obtain the
name the task that was run previous to the current task. The reason I
ask is that I'm hoping to create a single "Execute SQL Task", that
logs errors to a table via a stored procedure. If I were able to