This should be easy because I'm sure it's an everyday kind of task. I've just never had to do it before. I am using an .adp project with SQL Server 8. A couple of months ago I made a copy o...
Here is my code:
SELECT
MEM_ID
,GRP_FACT
,CAST(REC_NUM AS DECIMAL(9, 2)) as REC_NUM
,CAST(GRP_FACT_CNT AS DECIMAL(9, 2)) AS GRP_FACT_CNT
FROM t_OUTR_REC_CNT a
where MEM_...
There is a daily job that executes a DTS package that imports a flat file into a table on a SQL SVR 2005 database. When the DTS package executes, if the daily file is empty it abends.
...
Greetings,
I am looking for a tool that will allow you to migrate a group of DTS\SSIS packages all at once to a new SQL Instance. Are there any existing third party tools available to achie...
I am making a DTS package. I have a stored procedure that when called returns a recordset...its not being stored into a temp table...
I know if this was just straight sql I could pass it ...
Hi,
I Need to change dd-mm-yyyy to mm-dd-yyyy on import of Excel file to SQL server 2000
Sometimes I receive Excel files with a date column which has the format of dd-mm-yyyy
My preferred...
I have several MAP files that I need to maintain to support some reporting from a small data warehouse. The problem is the data source for these map tables is a manually maintained XLS file. ...
Hello,
I have few question about SSIS
1)I am trying to transfer data into SQL in SSIS project.
I can successfully transfer data into new table. However date/time in text file is not bei...
When executing DTS using stored procedure in SQL 2000 getting error: -2147024888
This solution is not new. It's been working OK for a long time and out of nowhere start generating this error.
I'm trying to incorporate a piece of code that I got from a different post on this site. It deletes rows from a worksheet within an excel workbook. The piece of code that is giving me proble...
I need to get values from sql for a specific item and summed quantity but for each customer
as one record. I would need to convert the orderdate to just the year
I'm hoping to get the fol...
Could you please explain me the process of how to move DTS packages and stored procedures from DEVELOPMENT environment to PRODUCTION environment?
Thanks!
I'm try to understands what is the diff between these?
<
/D[ts] package_path
(Optional). Loads a package from the SSIS Package Store. The package_path argument specifies the relative pat...
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...
One of my clients has a scheduled job that runs a DTS package every day. Recently the job began failing. I set up error logging on the DTS package, and have included the error below.
I ha...
I have a text file generated from an attendance system which contains the following fields - date, department, onsitehrs, ontaskhrs. I have created a SQL Server 2000 DTS package to import thi...
i mistakenly ran the below dts package ... and with 10 sec before completion i canceled the process ...
Did it put the rows or will it be rolled back ?
Hi all, I don't know of any way and doubt that I can do it, but just in case, does anyone know of a way to kill a process from a DTS package. Like if I run a DTS package and it uses an excel ...
MS SQL version: 2000
I have a DTS package that will run if executed directly. When executed from a calling stored procedure I am getting a runtime error. The construction of this DTS and e...
Hi Experts,
I have a suituation where i need to read the text file and save the data to the staging tables. I figured out that
i need to use FTP task and BCp to accomplish the task. FTP u...
I have developed a package using BIDS, on one server.
I want to be able to schedule it to run on another server at 2am every morning. To be honest I havent any idea on how to import/export...
How would you do the following in a dts package.
I have an excel file sitting in one location of my network.
I would like to copy...not move an excel file to a different location on the ...
I am migrating over to a new 2000 server. The issue is the c: drive on the current server is now the d: drive on the new server. I have many packages referencing the c: drive as connections....
Hi,
I have this store procedure. where I first created a Merge temp table. filled the table with data then I get the MaxNum the count. I am having problem with do while loop I want to say...
Hi,
I am wondering if there is a way to use dtsrun utility on a server where there is no MSSQL server installed. I have created a dts package in another server and like to call this in ano...
