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...
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.
...
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 envi...
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...
I am trying to write a SQL Server 2000 DTS package that will pull down a file using SQL Server's "FTP TASK". The catch is... the file that I am trying to pull down has a filename that is based...
Hi,, I'm trying to use a left outer join along with an inner join,,,
Select CMRC_Categories.CategoryName,cmrc_products.productID,modelname,active,unitcost,listprice,thumbnail, longdesc, eve...
I have a table that keeps track of trucks going in and out of our yard...sometimes (because the guards are lax) they will enter the same truck twice...so, at the end of each week I go and find...
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...
Hi,
I am using a File System task in SSIS. My source file is a standard xls output file. i have a for loop container and in this container i have a variable. I need to somehow in the File Sys...
I am trying to create a DTS package that pulls in data from an excel workbook with 3 excel sheets and manipulates the data. I want each sheet to be loaded as its own table. I have a stored pro...
Hi,
Can anyone please tell me how to import text file in SQL 2005 64bit using BCP utility?
Thanks
Running Sql Server 2000 on SBS 2003 premium fully patched.
I have a fairly large text file filled with comma delimited data. I need to read it as fast as possible.
I am not an fso expert....
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...
Hello Folks,
I've got an SQL Agent Job that is calling a SSIS Package. The package needs access to a mapped drive, and is deployed to the server. I can successfully call the package when i...
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 have data in a column called State each state is inside double quotes such as "Maine"
and I want to remove the double quotes so that it is just Maine without double qoutes.
How do I ...
I have a SQL task in a DTS procedure. In the sql task, I declare a variable and set it a value using GetDate(). I run my package and it errors stating the following message: "Must declare va...
OK...before you guys say anthing, I've got a Proxy that runs the package as the exact same user I use when I log in. So I don't think it's a permissions issue, That being said...
In my Exe...
Executed as user: BUZZNETWORKS\svcMSSql. ...0.3033.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:00:14 AM Error: 2007-06-14 11:00:14.35 Code:...
Hi Experts,
Currently using SQL Server 2000 but I could update to 2005 soon.
This is what I wan't to do from a SQL DTS:
1. Rename existing Excel file adding the date to the name (ex: Fi...
Okay, I'm reposting this because I never got an answer and I REALLY an answer to this. Please help.
_____________________________________________________________________________________'
...
I have three (3) tables:
a. Products with fields Id, SKU, ProdName, Category
b. ProductInventory with fields QtyOnHand and ProductId (a FK from table Products)
c. InvUpdate -- this is ...
How do I run a dts package from Query Analyzer? What is the syntax? Thanks.
Im trying to Connect to Oracle Instance from my ActiveX Script Task using ADODB Connection. Created a System DSN with the Oracle Client Driver installed on my server (Windows 2000 & SQL Server...
How to generate SQL script to DROP all triggers
How to generate SQL script to CREATE all triggers
