Migrating DTS packages that use mainframes source to SSIS
I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?

Answer Question   |  April 12, 2010  6:26 AM
AS400/DB2 source, DTS Migration, DTS package, DTS packages, SQL Server Integration Services, SSIS, SSIS 2005

SQL DTS package scheduling
When a DTS package is scheduled to run at a specific time of day, is it done through the use of a stored procedure or a job?

Answer Question   |  December 8, 2009  1:53 AM
DTS package, SQL Jobs, SQL stored procedures

My DTS package runs normally, but hangs when run as a SQL Job
Hi, I’m trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I’ve designed a DTS local package as follows: ‘********************************************************************** ‘ Visual Basic ActiveX Script ‘************************************************************************ [...]

Answer Question   |  April 29, 2009  6:01 PM
ActiveX, DTS Local Package, DTS package, Job scheduling, Microsoft Access, SQL, SQL Jobs, SQL Server 2003

Creating DTS package for Linked Server database
There is a linked server database for which packages are to be created using DTS wizard. Please can anybody help me by telling how to create packages. Thanks

Answer Question   |  February 6, 2009  3:53 AM
DTS Import/Export Wizard, DTS package, Linked Server database, Linked servers