I have the following code. The problem is that the source cell (BTN) can be either empty (NULL), be a number formatted as text, or be stored as a number. When I run the transformation, it sees...
Hi
I'm trying to export to csv using DTS. Rather than double quote every field, I need to double quote specific fields. Can this be done
thanks, mark
I need to develop a way to export specific tables out a SQL Server database into multiple text files (one for each table) and to be able to set this as a scheduled task. I know we can export ...
Hi,
I am trying to open a text file with Delimited(|) on web using T-SQL openrowset but I am recieving an error.
The OLE DB provider "MSDASQL" has not been registered.
I have a DTS package containing two global variables, FromEmailAccount and ToEmailAccount. (These variables are set at design time to normal looking email addresses.)
The package also c...
We are currently running a DTS job nightly that backs up a table from an IBM Universe DB to a local SQL DB to be queried (via a vbscript file) throughout the day. The source table is very lar...
DTS package was created in SQL Server 2k. The package runs an ActiveX script to check if a file exists in a directory. If so, it moves the file to a new location, creates the result table from...
Help me!
I use SQL server 2000, I created DTS and keep them in local packages what can i do if i want to back up these DTS like a backup database
Thank you in advance
somchai_edp
This might be tied in with question http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_22811697.html. I'm not sure, as I am only about a week into using DTS and still le...
We defined some DTS packages and set up linked servers in SQL 2000. Now we migrated our
databases to SQL 2005. How to move all DTS packages to SQL 2005 server? SQL 2005 doesn't use DTS packag...
I'm looking at a DTS Package here that is launched from a Stored Procedure. The DTS Package writes data to an Excel spreadsheet. For this it uses a JET connection (apparently!)
The problem ...
Running SQL server 2000 on SBS 2003 server fully patched.
I am using DTS to copy an Excel file to a SQL table. Need help understanding the error message generated by DTS (see below)
My...
Automate Trace:
Is there a way to automate a MS SQL Server 2000 sql profiler trace so that it starts at a given time each day and stop at a given time each day. I am tracking a certain proce...
We are working with a healthcare billing application called Medisoft. Currently we are using MedStar but we are converting to Medisoft. I am attempting to insert the Medstar (MS SQL) into Medi...
In my DTS package ---->Execute SQL task I have list of querys I want to comment out each and every query at the begining and the data source for my DTS package is MS Access.
when i tryed --qu...
Hi,
Below is an error from my dts package that I extract out from sysdtspacakgelog table.
Step 'FTCV_connect1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Pa...
Hi Experts,
Is it possible to include the execution of an autoexecute MS Access macro as one of the tasks in sql server DTS?
I would like to schedule the opening of the MS Access Databas...
An Excel workbook contains a worksheet to be imported into a SQL2000 table. The sheet shows a couple of rows of text as header and rows of column headers/footers and blank dividers between gro...
sql server 2000
i have a simple DTS package that extracts millions of records from a table to a csv file (simple transform data task). the next step in the DTS is an "execute process" task wh...
Dear Experts,
I have a foreach loop in my SSIS package.
In this loop there are many Data Flow, Execute SQL tasks, Execute Process Tasks and Script Tasks.
The Loop is running properly.
No...
I am looking to create a SSIS package that will
a) Query db to return a bunch of IDs
b) this id would then be used to create a report in PDF format
- how can I access this report ... web...
Hi all,
I get the below error. There is no row at position 0
at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
at System.Data.RBTree`1.get_Item(Int32 index)
at System.Da...
Does anyone know how to create a tab-delimited file from a SQL query from within a DTS package? Should be simple enough, but having some trouble.
Thanks in adavnce,
jm
Hi,
I want to import some .dbf files to SQL server 2000 database. I am facing a proble while importing that Import/Export wiozard of SQL doesn't show the list of tables from the foxpro data...
I have a SQL 2005 job scheduled to run nightly at midnight. The scheduled job fails. If I run the job manually it runs fine. If I'm logged into the server and have SQL Studio open then the sch...
