I trying a simple test of iterating over files in a folder and executing the
script on a sql connection.
I configured the ForEach Loop container and dropped Execute SQL Task in it.
I also created a FileConnection and configured in "Execute SQL Task".

Dear Friends,
I am developing a data warehouse in my sql serevr 2005 and I want to connect
directly to oracle rdb, however the current oracle rdb odbc is not working
properly.

I downloaded the file watcher task, and I'm using it for the first
time.  I set FindExistingFiles = true, but when I run my package it
only processes 1 file.  How do I get it to read all the files in the
directory, instead of the first one?  Do I have to put it in a loop or

I have Event Handling set up for most of my packages and for the most part,
it works pretty good. I set up an Event Handler for the Package's
OnTaskFailed event and have one Send Mail Task in it. I use an Expression in
my Send Mail Task that builds a simple MessageSource as:

I have an execute sql task using an OLE DB connection that is executing a
stored procedure that has input and output parameters.  I can get the task to
run, but the variable that is mapped to the output parameter is not getting
updated.

I've recently migrated my db to Sql Server 2005. With Sql Server 2000 I
could easily execute my DTS packages from an Excel's macro exploiting
the following VBA code:
Dim dtsp As New DTS.Package

64b SQL2005 EE and all clent tools installed on the same server. Logged as
local admin user  Im trying to create a new connection in DTS Designer but
after succesful test of the connection it errors out with
The new connection manager couldnt be created. Additional info : ...

If a task fails in Data flow i want to write the failed row to a text file
and the flow will continue.How can i write the failed row into a text log
file.

Hallo gurus,
can abybody help me with this?
I have installed SSIS on SBS2003, I can connect database engine but I
can't connect to Integration Services. I'm getting following message:

 I know I can output a table to a text file by using data flow task.  
However, the table that I have is a dynamic table (Different Columns)
everytime when the Package runs.  Since the column mapping has been created
in the data flow task, I am not sure how to export a dynamic ...

I'm creating a package to import new records into a table on a seperate
server.  I've set up the OLEDB Source for both servers and created a Left
Outer Join Merge Transformation.  This works as fine, but I'm unable to
include the check for NULL values. I only want to return rows ...

I am using the Transfer SQL Server Objects Task Editor from SQL2000 to
SQL2005 but am unable to transfer the Constraints.  Any help with this would
be appreciated.
sck10

I have a package with lots tasks and want to use CheckPoints, but have had
limited success.
On the Package Properties, I set the following:
CheckPointFileName: <some valid path and filename>

I have a simple Execut SQL task using an OLE DB connection to SQL 2005. I
want to run a simple stored procedure and pass it an integer value from a
package variable.
The task's SQLStatement is "EXEC MyProcdure @intValue. In the Parameter

Hey guys
Scenario
---------
I'm basically pulling a load of old data periodically from a bunch of client