I have a SSIS package that executes a SQL script against few SQL Servers in
our environment. I setup SSIS file based logging to capture error messages
but I can't get the server name where the error happns on. How can I include
SQL Server name in logging?

I have a script task in a For Each loop that I want to execute for each row
in a recordset but I'm having a problem accessing the row variables from the
script.
I use a SQL script task to get the recordset and put in an object variable.

In a dtsx Execution Results panel , is it possible to see the complete text
of a message ?  For example an error message that is truncated.

I have a data flow task which uses an Oracle view and loads the data
into a SQL Server table
Currently the SQL command is hard-coded in terms of the years to be
captured (...where years in ('2006' , '2007') and that works fine.

I am trying to import a text file which exists a column that has some NULL
values.
I am unable to import the data and have this NULL not report an error.
I tried writing the following expression in the Derived Column

I'm running standard 2005 with sp2 on both my dev and prod servers. I can't
get the sync to work it say I don't have the correct release.
?
thanks

Hi to all,
I've create a package that had to migrate record from an as400 to a
SqlServer2005.
When I launch the package from visual studio it work's fine, but when

I'm trying to standardise our SSIS package development. What do others do
regarding documentation and annotation? The normal text annotation is very
basic and is fine for adding comments above tasks etc but if I want to add a
generic formatted header containing name, author, ...

i've done my googling...and the answer appears to be capturing the
dynamic SQL statement in a variable and then referencing it as "SQL
command from variable".  But I wonder if anyone has found a
'traditional' solution for the following SQL statement:

I've tried the following in a non-data flow script:
   Public Sub Main()
       Dim cm As ConnectionManager = Dts.Connections("db")
       Dim cnn_ As SqlConnection

i've googled and reviewed the event handling chapter in my wrox SSIS
book..but have not found the equivalent of the old 'resume next' vb
statement.
I am creating/droping a temp table for excel imports....need to trap

I have a dtsx with a Flat File Source that apparently can load data such
such as "03-Apr-1990" as a DT_DBDATE ...
( I say apparently because if I specify this col should be DT_DBDATE there
is no error listed in the Flat File Source )

I'm not sure this is possible in SSIS ...
Using a Data Flow Transformation Derived Column piece,  I would like to
transform a DT_DBDATE to ticks ...
Ticks are the C# DateTime's internal smallest unit = 100 nanoseconds

Hi, I got a mysql dump and have to import the database into sql-server. Does
anybody know how to do that?
Susanne