i'm working on building a generic error handling routine for a
package.  I've googled my way to the point where i can iterate thru
the input buffer....but don't know how to get the actual value in the
column buffer so I can copy it into the  appropriate output column

Trying in SSIS to do something which technically should be rather simple.  
1) create a for each loop that contains as a variable the name of an mdb
database in a folder
2) use a stored procedure that prepares a query based on the variable name

I have two SSIS packages that import from the same flat file into the same
SQL 2005 table.  I have one flat file connection (to a pipe delimited file)
and one OLE DB connection (to a SQL 2005 Database).  Both packages use these
same two Connection Managers.  The SQL table allows ...

Hope I'm in the right Newsgroup for this question. I'm sure someone will put
me right if I'm not :)
I'm trying to build a SQL Server 2005 SSIS package in VS2005.
The package, on the face of it, is fairly straightforward. It needs to

I have a couples of DTS jobs set up for data import from Oracle to SQL
server. They all appear to run fine when triggered manually. However,
when they are scheduled to run routinely in  SQL server job agent, these
jobs may OCCASIONALLY got hanged. Some jobs which normally finish ...

I have an SSIS package that runs perfectly in BIDS but when I try to
schedule it as a job, it fails.  
Can anyone give me a place to start to troubleshoot this or has anyone
experienced this problem?

I created a SSIS package that imports an Excel file that has columns with >
255 chars into a SQL table.
I am getting error "Text was truncated or one or more characters had no
match in the target code page"

I have a local development machine running on Windows Vista SP 1. My package
( in SSIS 2005 ) conncets to a local DB ( in dBase ) and derives a new column
with codepage 865 ( OEM Nordic ). This doesn't work and I get wrong
charachters into my destination in SQL. The same package ...

I have a csv file with first 2 lines having less columns than all the rest of
the lines.  The first line has 6 columns, the second line has 4 columns, then
all the rest of the lines have 14 columns.  My destination table in sql
server also has 14 columns.

Hello.  I have an SSIS package, which runs fine in Visual Studio.  I create
and deploy the package to the SQL Server set all the connection properties,
etc... and then schdule the package to run in teh job agent.  The package has
many steps, including running an external program ...

Any idea on casting the Object type to String type in ScriptTask's Design
Script area.
Thank you in advance.
Daniel.

i know ssis allows to insert from a csv file into sqlserver (2005) tables
but is it possible to either update and/or delete records with an ssis
package based on a csv file?
thanks for you help.

I have a DTS package that copies contents from an Excel spreadsheet.  In the
spreadsheet all columns are formatted as "text."  One column consists of Zip
codes.  They are a mixture of 5 and 9 digit zip codes.  The 9 digit zip code
has the hyphen in it (12345-6789).   The zip code ...

has anybody ever used sftp to tansfer file? is there a way to do this in
sqlserver 2000 and/or sqlserver 2005?
thanks in advance.

I have an OLE DB Source control that I am using to collect data from a stored
procedure. THhe stored procedure first assembles the data in a #Temp table.
It then does some work to the #Temp table and finally returns the data via a
Select statment from the #Temp table. I have ...