Is it possible to create VB code from a dtsx package?  I need to make all of
my packages programmatically but I thought it might be possible to create
them using the gui then "export" them to VB .net.

I have a flat file that will import data into multiple tables on SQL.
The flat file has columns with the actual data, but I need to insert that
data into multiple tables, while also inserting the correct foreign keys
back into the main table (where the foreign keys are your ...

i'm new to SQL server 2005 integration service(formely DTS), i was trying to
build my first integration project  but i'am facing an issue while trying to
add an SQL Execute task to the control flow tab of Business intelligence Dev
Studio. I'm not able to add any other task to the ...

I have near one hundred of DTS packages used for data transferts between a
Sybase DB and a SQL 2000.
We are planning to migrate whole SQL 2000 servers to SQL 2005, but theses
packages cause some problems.

   I'm trying to do a lookup using a DT_DATE derived column with a Datetime
column.  Can't do that.  I tried changing my type from DT_DATE to DT_DBDATE
with no luck.  How can I do my lookup??  I really can't see any other
option.  I hope I'm simply blind! :)

I'm developing small component for logging error data which sends error
data to uor application via SSIS CustomEvent.
All works ok,  collecting this data works very fine but  our EventReporter
component is used (in most cases) as destination for ErrorOutputs of other

I've got a flat file source that contains 158 columns.
I've created a package of 24 objects that passes the flat file source rows
and creates records in a wl_analysis table depending on the values in 6 of
the 158 columns.

My appliactation executes SSIS package from code, and stores log produced by
XMLLogProvider in database. It's very useful until i found following
fragment in this XML log:
 <record>

I have a 158 column delimited flat file source file that I'm ripping apart
into multiple tables.
Often I only need 10 or 20 of the flat file source columns.
The flat file source editor pops up a "select all columns / unselect all

I am trying to import a delimited text file where the record delimiter is a
TILDE (~) character and the field delimiter is an asterisk (*). The records
consist of a variable number of columns. The file looks like this :

Very new and just started playing with integration services in Visual Studio
2005.  I got one simple project working, and I am looking for pointers in
good practices in exception handling.  Any input will be greatly
appreciated.  Examples will be very helpful.

Has anyone located a reliable source of documentation SSIS error codes /
message yet ??
I've got an OleDB destination that is simply refusing all records passed to
it.  The data viewer

Ok,  I think I'm ready for my next step on the SSIS learning curve.
We have a HUGE (160 columns per record) table in our old well_log system
that we're trying to split into multiple tables in our new system,  it's
been unloaded into a delilmited flat file source (380,000 LONG ...

   When moving a package from my development system to my production
system, the "authentification" to my datasource/destination are kinda lost
even if I make sure I checked the box for allow password saving.
   I tried copying the package SSIS source on the server and opening ...

   I have a package that runs fine on my SQL Server 2005 Ent. box when
right clicking on the package in MSDB.  However, when trying to schedule it,
it failed and there's not much error description other than "The package
execution failed.  The step failed." in the job history.  ...