I need to migrate few tables from MySql to SQL Server 2008 and
I connected to MySql with ado.net connection as a source and OLE DB to SQL
When I executed the pakage I got error that says
"the conversion between types DT_UI4 and DT_I8 is not supported"

I have an SSIS package that runs multiple times a day.  The package
pulls all data from an AS400 table (F55EZIVD) and imports it to a SQL
table (chatt_INVOICE_ITEM_TEMP).
Now I would like to write back to the AS400 table and update a field

I am running a SSIS package to backup our databases on a SQL Server 2000
server.  On the Backup Database task I checked the box to create sub
directories for each database.   I saw that SQL2K does not have the extended
stored procedure.  I tried to add it manually from the ...

I am trying to execute a stored procedure in Execute SQL Task. The stored
procedure neither accepts any parameter nor returns anything (except for the
default return integer). It used to work fine earlier and I am not sure what
got changed as I am getting this error

I have a Flatfile-Source and an OLE-DB-Destination (SQL Server 2008).
I configured the Flatfilesource and added a Connectionmanager.
The Preview of the Connectionmanager looks OK.
I constantly get errors of the kind:

SQL2008
I have a VM (virtual PC) running XP that I use to connect to my office.  The
VM has been added to the domain and my user account is an admin on the local
box.

Trying to pull data from a DBASE table. Using SSIS and created an SSIS
package with OLE DB Source. Then using Data Conversion Transformer Editor.
All DBASE source data is smaller than 50 characters. I have available input
columns set to string[DT_STR] and Length=50 and mapping ...

How can I test for a condition (logical OR) without causing a task/package
failure?
I'm using a date table to determine whether the package needs to check for a
file on a vendor's ftp site or not.  If I use a script task, I'm limited to

Is it possible for a SSIS pacakge to prompt for a parameter/variable before
running?
Thanks.

I'm using SSIS 2008 and I need to export a table into multiple CSV files
The requirement is the file can not be bigger then 60MB
My table contain few millions raws
How do I export into multiple csv files < 60MB each?

Currently, we have a 90gig db which is updated once daily with more than 60
gig worth of data.  The update is written in c# and utilizes stored
procedures.  There are only a few transactions, but they are enormous, I
guess to maintain integrity of the data.

Hi - I have an SSIS package with two Execute SQL tasks. The first task when
runs needs to get max value from a table. Here is the query SELECT MAX(ID)
from Table1. I want to store the result of this query into a variable which I
want to use into second task

Hello all!  I have an SSIS job that I run manually, whenever I get the
word that all data is processed for the month:  MY_SSIS_JOB
Doing some research I found that there is a maintenance table
(tbl_MAINT) that has columns, FY, PER (i.e., Period), and CLSD_FL