my packages generate the "The script files failed to load" error but the
PreCompileScriptIntoBinaryCode  is set to true!!!
I edit the script, close it, execute the package, its ok.
but later, I can rexecute the package and the error appear again!!!!

In using SSIS I have the following workflow:
-Truncate table (SQL Execute component) [a]
-Identity insert (SQL Execute component)  [b]
-Then the ETL (Data Flow component) [c]

I am stuck, is it not possible to set the connection for logging dynamiccaly
?Is there any solution to make it dynamic?
Thanks,

I have windows 2003 Enterprise Edition Server SP1
with
sql server 2000 Standard                          2000 Databases
sql server 2005 Enterprise instance 1         Report server

I am porting a system from DTS to SSIS.  The old version runs packages
programmatically loading and running a DTS.Package2 object.  I can load and
execute an SSIS package using the Microsoft.SqlServer.Dts.DtsClient API, but
the package runs locally.  I have a lot of questions ...

In SQL 2005, what's the best method to import a file(via an SSIS package
that would have a schedule) if that file:
1) Exists
2) Is not empty

In SQL Server 2000 DTS there is an Extended Connection properties
window that you can set the IMEX property for importing Excel
spreadsheets into a SQL Server table.  Does anyone know where this is
in SQL Server 2005 SSIS?

How can I get the return value of an SP to a package variable.Is the only
way is Result set type...
Thanks,

This has been happening to me since I started using Configuration files.  I
use one XML config file that stores Machine Specific settings and one
connection string to my Metadata database.  The problem is the database
connection.

I have been struggling with this SSIS package configuration the whole week.
OK this is what I got so far. Bear with me the details.
I create a database called SSISConfig, which contains a table called
PackageConfiguration. This table includes three sets of configuration based

I have a SSIS package, saved to a disk.  Can a SQL Server 2005 express
edition execute that package?

I'm new to SSIS.... and trying to build what I wold consider a rather simple
package....  I'm trying to pull a select number of records from a DB2
datasource and move the records to a SQL server.  Here is what I have done
and what I'm getting:

I use SSIS to insert some data from text sources to SQL server 2005. I use
check constraints option. Is it possible if iserted record has the same
primary key as existing record in table to replace existing record? How to
make it?

I am trying to set up a data flow task. The source is "SQL Command" which is
a stored procedure. The proc has a few temp tables that it outputs the final
resultset from. When I hit preview in the ole db source editor, I see the
right output. When I select the "Columns" tab on the ...

I'm using a data flow task having a raw file destination
in a foreach loop. Basically it looks like this:
  file system task: delete raw file
  foreach ....