View Complete Post
Please comment the pros and cons of both methods.
Thanks in advance.
I am looking for best solution to perform incremental data load from MySQL database to SQL Server 2008. I tried to follow instructions from articles on incremental data load in SSIS using MD5 hashes but I failed to make connection in Lookup transformation
editor between MySQL Id (4 byte unsigned integer) and Id in SQl Server 2008 table which is bigint. i tried to add data conversion and convert MySQl Id to string. It works fine when you map this field directly to OLEDB destination but in Lookup
component it failed.
Any input greatly appriciated.
We have a moderately complex SSIS package that uses a script task to dynamically create a Transfer SQL Server Object task, which then moves data and schema of a varying definition
from source to destination. The SSIS package was written in BIDS 2005.
The source system is still SQL 2005 (with latest updates) and the destination system is now 2008r2 (with latest updates).
When the package run, we get the following error when we try to execute the dynamically created transfer task: Description: Execution failed with the following error: "Version90 database compatibility level is not supported.".
sp_dbcmptlevel for the source and destination databases returns "The current compatibility level is 90.".
Master on the target system is predictably at level 100.
This leads to several questions:
Using a data flow task I am trying to load data from a table in sybase server to sql server. There are approx 10000 rows in the sybase table, however for some reason which I
am not able to find out, at random certain no of rows are getting inserted. e.g. in one run 800 rows then 200 rows etc.
Can somebody please guide me on this?
I would like to identifying the source & destination tables of the data flow or the transformation task.
I need to create a custom component which i can put into existing packages which can do some validation.
Please suggest ways i can accomplish this.
I'm new to SSIS & require help for the below 2 query's:
1.We need to import data from Microsoft Access using SSIS 2005 to SQL server. Could you please let me know the steps involved to achieve this.
2. We have web access tool & data has been stored. I need to import the access data from the Web tool to SQL server using SSIS 2005
actually we are planning to move data from GreenPLum data base to SqlServer 2005 data base using SSIS as ETL tool. What type of connection manager can we use. Is to good to use OLEDB connection manager or ODBC connection manager.
Please give me a reply as soon as possible.
When I'm trying to load the data from SQL Server into DB2 database. It's trowing an below error. Can anyone help me what would be the possible resaon and workaround for this. ANy help would be much much appreciated.
Error: [OLE DB Destination ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x8000FFFF Description:
" CLI0125E Function sequence error. SQLSTATE=HY010"
What exactly I'm doing is ......Loading data into
Loading the data from sql server into the view on DB2
Here Brian Randell presents everything you need to know to get started with Visual Studio 2005 Team Edition for Database Professionals.
Brian A. Randell
MSDN Magazine February 2007
Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.
Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.
MSDN Magazine October 2006
The latest releases of WinDBG and Visual Studio know exactly how to use source server, so its benefits are available to both .NET and native C++ developers. See why this is so important in tracking down bugs.
MSDN Magazine August 2006