Are there timing issues, i.e. competing tasks, within a DTS package? I have a package that parses a text file into two db tables. Each line/record in the text file is pipe delimited and some of t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23490123.html
Hi all,
I have a very simple DTS package imports some data from a CSV file, into a SQL Server 2000 table.
My issue is that from time to time, my CSV file will include records that already exist...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23666303.html
I have a DTS package that loads data from a spreadsheet that is extracted from another system. I want to be able to insert a date/time stamp for when this data is loaded and I cannot figure out ho...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23320587.html
Is there any way to call a specific task within a dts package using dtsrun?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_22810831.html
i have a mapped drive with a text file i want to run the dts on.
i do not want to run the dts if the file does not exist.
i have a workflow script that uses
the following
Function Main()
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23085664.html
Zones:
MS SQL DTSDate Answered: 01/17/2008 Grade: A Views: 0
How to add a new Excel Sheet to an Excel file dynamically when the record count exceeds 65000 as one worksheet supports 65000 rows while exporting data from a SQL database to Excel file using DTS.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23228657.html
I am trying to set up a DTS package that can dynamically change the SQLSourceStatement in a DTS Data Pump based upon a user's selection.
So, if user selects option 1 (via InputBox in ActiveX tas...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23268811.html
I'm trying to create a simple DTS that reads data in an Excel file and updates data in a table from it. I created an Excel data source and a SQL Server data source, with a Data Transform task betwe...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2332...
using SQL Server 2000, in a dts package when I create a connection object, if I type in the full address of the named instance including port I can connect without any problem. However, if I try to...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23361320.html
Zones:
MS SQL DTSDate Answered: 05/01/2008 Grade: A Views: 30
I am using SQL Server 2000. I have created an excel file using the Transform Data Task to an excel file. After the file is created, I send an email using ActiveX with the file I just created as a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23415950.html
