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:

I have a SSIS package that uses a execute process task to run a batch
file to perform robocopy. When I run this package as an agent job
using an administrative account on 64 bit environment, it runs fine
and does everything as expected.

Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.

Ok, just re installed all client tools from sql 2008 standard edition.
In studio in the drop down under object explorer for the connect button.
There are 3 options missing? please help
Analysis Services

Hi
I SSIS 2008 is throwing the exception for null column values in script
component of SSIS dataflow task. Same script is working fine in SSIS 2005.
Please advice me the fix.

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.

Many problems with performance and safety of your computer can be solved
easily with an updated antivirus and recognized. Antivirus Free Download
Microsoft best practices in:
http://yourantivirusfreedownloadonthissite.blogspot.com/

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.