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.
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 dtsThere was a communication link error while I was using SQL Server Native Client 10 in an SSIS Data Flow component. …
sql-server oledb ssis dtsI am trying to import a PSV file into SQL Server 2008 using SSIS. All is working fine apart from one …
sql ssis dtsSynchronization has always fascinated me, or to be precise: why a .ts can be viewed in sync by media players, …
video synchronization dts ptsI'm getting a persistent error: The element cannot be found in a collection. This error happens when you try to …
variables ssis dtsI 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 dtsI 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-toolsI need to migrate all the DTS packages created in SQL Server 2000 to SSIS 2012. What are the differences between SQL …
ssis dtsI need to convert data that already exists in a MySQL database, to a SQL Server database. The caveat here …
mysql sql-server ssis dtsIn 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