SSIS 2005, OLE DB source to SQL 2005.
If I have either direct input SQL command, or SQL command from a variable, I
understand the size of the command is limited to 4000 chars.
What options do I have for SQL commands greater than 4000 chars in SSIS ?

I'm reading a .csv file that has a column such as 17June2007:00:00:00, how can I convert this column in my Derived Column routine so its inserted into my DateTime column in my database?
so far I've tried
DT_DateTimeStamp
DT_Date

I created a derived column with a length of '50' the column that the derived column is mapped to has a length of '50'. when I execute my task I'm getting the following error:
[Derived Column [424]] Error: The "component "Derived Column" (424)" failed because truncation occurred, ...

Having ETL hell problem on trying how to read source OLTP into a many to many scenario and group on an area called: Disabilities.
Example:
Here is my scenario:
 a.. If I have 4 Determination's done, with 1 to many disabilities and 1 to many evidences tied to each disability

Making the move from DTS to SSIS and having a lot of difficulty. Already
have Haselden's book and can't seem to figure out how to recreate my rather
elaborate DTS packages (lots of ActiveX scripting and things I probably
didn't understand completely) in SSIS. I've also tried the ...

I am using the "Advanced Editor" on my Excel Source component to
change the length on some output colums from 255 to 1000.  When I try
to change the length on the column under "Excel Source Error Output"
it won't let me; running the package gives the following error:

I am able to connect to SSIS when I remote login to server.  But, I couldn't
connect to SSIS from my client tools.  I got the following error.
Connect to SSIS service on machine xxx failed.  The RPC server is
unavailable.  

I am new to SSIS and I am trying to figure out if part of my SSIS package can
run a reporting services subscription based off a specific time and drop that
report in a specific folder.   Is this possible in SSIS?    If so, how would
I do this?

Hi I've been having issues with this task.
I'm using it solely to delete Biztalk Backups which cannot be deleted any
other way apart from runing scripts etc (i.e its not part of a maintenance
plan.)

can I save the execution log for an SSIS package?
Thanks.

I want to configure some values through ConfigurationSettings.AppSettings,
but I do not know how to include Application Configuration file into SSIS
project. Thanks
zlf

I created a SQL Task that provides a CustomerID (and a unique filename) to a
ForNext Container. Then within the ForNextADO container I use that
CustomerID/variable as a parameter to use in another query which gather
rowsets from a log table for each customer.

I have a file that contains fixed length fields.  the trouble I'm having is
that it has no record separators... no CR/LFs... one record butts up right
against the other... the Builk Insert Task seems to require a separator...
can anyone suggest how I could consume this file?

I have a Data Flow task with 12 different tables that are transferred.  In
DTS, I could click on the transformation line between the source and
destination and run just that one transfer.  I don't see how to do the same
in SSIS in the Data Flow task.  Is it possible?

hei everyone, I have two questions:
1. I need to do a database lookup to determine the name of a file I should
look for in an FTP server... the FTP Task allows me to specify which file to
grab via package variables but I can't figure out how to set the variable