Recently our development server is upgraded to sql server 2005. My DTS packages are saved as file system. I want to test all DTS packages in 2005 server.
Simply execute that DTS on my new ...
The source DB is SQL, fixed lenght fields from JD Edwards (now Oracle) Enterprise One, version 8.10. The destination is a CSV file, variable length fields stored on our company network drive....
I have a DTS package that loads data from a spreadsheet that is extracted from another system. I want to be able to insert a date/time stamp for when this data is loaded and I cannot figure o...
The dts package name is RUNTHIS.
Thanks.
I am writing a DTS package that reads in a text file. If the file is larger than 60,000 lines it breaks it into files of 60,000 lines.
I am using the fso.line property to check when the rea...
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...
I have a SQL Server job which:
1. deletes rows in PRODUCTDUMP table
2. inserts into the PRODUCTDUMP table all rows from excel spreadsheet (see code snippet)
3. removes FK on BASKETITEM ta...
I tried to export all data from a DB to a new one on the same server.
My steps:
Create DB
Create tableschema
create users
set loggin from new db to simple
start export / import wizard
s...
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.
