Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srinii2005
Starting Member
6 Posts |
 Posted - 2009-03-18 : 19:16:35
|
| GoodEvening Everyone,I migrated frim DTS to SSIS Package using DTS Xchange tool.I have 2 queries.1.The datatype for the column was "quotable" in DTS.But After i migrated to SSIS.It became "string [DT_STR]". will this create any problem in SSIS?Also what is quotable?2.During Migration, I got a message "Suggested Data Providers".In the drop down box There was "SQl Native Client OLE DB".And i clicked "Apply New Settings" and migrated.The exact message was"Migration Wizard had identified potential data provider compatability issue in SSIS for the connection [Microsoft ODBC Driver for SQL Server].Please Use [SQL Native Client OLE DB] insstead of [SQL Server ODBC].If you wish to use someother data provider instead of default suggested driver by the system then please select new data provider from the "Suggested Data Provider" from the drop down."will this create problem as well? |
|
|
|
|
|
Migration from DTS to SSIS