hI
I am moving huge volumes of data from a dbase file to SQL Server using DTS. The table into which the data is moved contains a clustered index and 2 non-clustered indexes. My problem is that t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23499508.html
Zones:
MS SQL DTSDate Answered: 06/22/2008 Grade: B Views: 21
Hi Experts!
I have one solution to migrate database and I use DTS to migrate data from old database (source) to new database (destination) by following
step.
- Create stored procedures for ins...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2324...
HI
I am having difficulties in trapping record count in DTS. This is what I do, I have vb6 application that transfer data from csv file into sql server table. I use DTS to do that in vb6 enviromen...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23249509.html
I am doing a data conversion and have built many DTS packages on a Sql 2000 server. These packages were moving data between one database and another on that same box. At the last minute we/they hav...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21871808.html
Hello All,
What I'm trying to accomplish.
Execute a sql statement
Take query results, and create a new excel file.
Within the VB Script define the name and path of the file, using that ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23090779.html
Hi!
I would like to generate a SQL query to find all duplicate records in my barcode file where each record of the barcode has a date range for valid date.
Say the table is the following...
...
http://www.experts-exchange.com/Database/Miscellaneous/Q_23397704.html
The first thing I need my DTS pkg to do is to check whether the files it's about to pull from our FTP server have the current date. (I can already use VBS to check file properties after they've be...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23418674.html
I want to setup a DTS package to export data to excel where the source and destinations are dynamic. This means the source fields will change every time the package is run. I need a way to dynamica...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23106649.html
Hello, I am trying to dynamically adjust the Error File name in the Error Handling section on the Logging tab of my DTS package properties. That is, if the package is named "B2B_Import_Daily", then...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23232171.html
Zones:
MS SQL DTSDate Answered: 03/12/2008 Grade: A Views: 10
I am transforming an Excel file to a CSV file. I have a numerical field that I need to format to only 2 decimal places. I'm doing the following:
Function Main()
DTSDestination("Charge 1") = ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23242338.html
