Top "Dts" questions

Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database.

How to create an SQL table and and populate it with Excel spreadsheet data?

Is there an easy way to create a table in SQL Server (2005) from an Excel spreadsheet. I'm thinking maybe some …

sql-server excel ssis dts
DTS_E_OLEDBERROR. Error code: 0x80004005.Difference between SQl Native client and oledb provider for sql server

There was a communication link error while I was using SQL Server Native Client 10 in an SSIS Data Flow component. …

sql-server oledb ssis dts
SSIS importing datetime column into SQL Server 2008

I am trying to import a PSV file into SQL Server 2008 using SSIS. All is working fine apart from one …

sql ssis dts
Audio/video synchronization, TS MPEG2;H264/AVC, understanding PTS in Handbrake

Synchronization has always fascinated me, or to be precise: why a .ts can be viewed in sync by media players, …

video synchronization dts pts
SSIS Element cannot be found in a collection (but I have them all listed!)

I'm getting a persistent error: The element cannot be found in a collection. This error happens when you try to …

variables ssis dts
Running DTS packages on SQL Server 2012

I read that DTS packages aren't supported in SQL Server 2012. I know there's a Backward Compatibility package/option out there …

ssis sql-server-2012 dts
SSIS Transfer Database task cryptic error message 0x80131500

I am using SSIS with VS2010 (shell) and databases going from SQL Server 2005 (32 bit)to SQL Server 2012 (64 bit). I am …

sql-server sql-server-2005 ssis dts sql-server-data-tools
How to migrate DTS packages to SSIS 2012?

I need to migrate all the DTS packages created in SQL Server 2000 to SSIS 2012. What are the differences between SQL …

ssis dts
MySQL to SQL Server transferring data

I need to convert data that already exists in a MySQL database, to a SQL Server database. The caveat here …

mysql sql-server ssis dts
SSIS 2005: "Append rows to the destination table" is greyed out. Why?

In SQL Server 2005, Import Data (SSIS), my desire is to import a text file and have it append to an …

sql-server-2005 ssis import append dts