We are using: SQL Server 2000 DTS....
I am trying to import 3 csv files into a table, each spreadsheet contains that years invoices. So there is 2007revenue, 2008revenue.csv, 2009revenue.c...
I had some DTS packages that I had used the migration tool in SQL 2005 to convert into DTSX. However I am not able to see the any of the DTSX files in my SQL 2005 Server. So what I am trying...
Hi SSIS Experts,
I have a dataflow task that creates a text file and posts it in a FTP share.
In need to rename the file attaching datestamp(current date of package execution) at the end o...
Using SQL Server 2000 and DTS.
I created and populated an ADO recordset using ActiveX script. Data is not coming from any tables or queries.
How can the recordset data be transferred to Ex...
I'm attempting to update existing records that are already in a SQL database through an Active X Script in SQL using VBScript. I do not want to add new records, I only want to update specific ...
Is there a function that pad leading zeros in activex?
I am transferring data from an AS400 to a SQL table via DTS. The fields that contain date values on the AS400 are stored on the 400 in numeric format, for example 112106 for November 21st, 20...
Hi,
I have a "foreach loop" in the control flow and have an "excel source" in data flow. I like to know how can I pass different excel file name to the connection string?
Here are the st...
Im using the SQL Server Import and Export Wizard that comes with SSIS. The data source is ibm's 'IBM OLE DB Provider for DB2'. I believe the MappingFiles that it should be using is 'IBMDB2To...
Hi
I have an SSIS script task that builds up a variable that is a SQL server statement. I need ot be able to execute that statement in the script task.
Here is the code I have
...
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 Active...
Experts,
I am using SQL Server 2005, which I just started using last week, with no formal training. I do have some experience with SQL Server 2000, however. I was named as the backup to t...
Hi,
I am using SQL 2000. I have a database on one server that i need to copy to another server.
I simply created a new database on the second server and named it DB2.
On the main server...
I have a CSV with three columns that I want to import into an SQL table. Upon importing, I need to add an ID column to my flat file data set that increments the next ID number that already ex...
I have created a DTS package in SQL Server that calls an executable. I have used the "Execute Task Process" in DTS to run the executable. When I run the DTS package manually, the program run...
I have a DTS task (which is a one-step ActiveX VBScript) which reads our database to send data to a business partner via XML. I have setup a job in the SQL Server Agent to start this task ever...
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...
Hello~
I need to take a stored procedure in SQL Server that takes data from multiple tables into a temp table then at the end of the procedure selects from the temp table. and use DTS to ex...
Hi, I have a DTS Package that run a executable file that generates a XML file. I would like to run it everynight and send it via FTP, so how can I do to send the XML generated file via FTP evr...
Hi everybody,
I'm newby in SSIS. I have been using DTS in SQL 2000.
Trying to learn how to execute SSIS package from C# code of ASP.NET web server.
For now testing with console app.
...
Hi All
I have a SQL2K db and an A2K.mdb, both have the same schema.
(The mdb tables were the 'source' of creating the SQL tables.)
I need to do an INSERT of all records in all tables ...
I heard I could run a dtsx job (designed in BIDs with Sql 2005 Std DE) on SQLExpress installed on another PC. The dtsx package can be run fom the command prompt using the dtexec.exe utility.
...
We are calling a SQL Server 2000 dts package from VBA code in AutoDesk's AutoCAD 2006.
We cannot use xpcmdshell on the server because we do not have the necessary rights within this corporat...
Let me first start out by saying that I'm not very good in SQL 2000. So any help would be great. What SQL command would I use to copy a SQL table from it's current location in the DB to a netw...
I have to generate a XML file every night. I've already done a class in C# ASP 2.0 that generates the XML file. I would like to know if is possible use DTS to get this class and genaretas the ...
