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...
I have just migrated all of my databases to SQL2005 and I just realized that I still need to mirgrate or recreate my DTS package from SQL 2000. However it looks like DTS is a thing of the pas...
Hi Experts,
I have a DTS (SQL 2000) that has a connection to a text file on a remote server. Is it possible, in the DTS, to specify to login name and password to use in order to access thi...
Good Morning Experts!
Here is my setup. I have a DTS package that I am trying to get to Email an XLS file. Everything appears to run fine, but I get an error when it comes to the Email p...
Hi,
I created a SSIS package from the BI management studio and executed the package.
It passes through the flow chart (I see green, green and red).
On the data flow, the color of the bloc...
I want to dynamic control a table copy job. For that reason I have made two variables source and dest.
The job works with the variables, but I want to loop and read new source and dest from a...
Hi, EE experts,
I run into "permission denied on object xp_cmdshell, database master, owner dbo." problem on my following code.
With cmd
Set .ActiveConnection = cn
.Com...
Im a database user whos kind of getting forced into a data admin role, and Im at the very edge of my expertise. Im working with a company who doesnt have a database administrator, but has...
We have a trigger set up on a table we use to track property information. It records each change to each field in a separate transaction log table. I know that it works because when I change...
Hi Experts,
On a weekly basis, DTS extracts the current month's data from an oracle source into SQL.
I currently hard code the month and year which means every month I go into the script a...
Hello
I've just been setting up a DTS job in VS integration services.
I'm now trying to save the package to a SQl server 2005 on another machine.
I am able to access the package loc...
Hi,
I have set up an FTP task using Enterprise Manager on my local PC. The task is defined on a one of our Database server. When I run package on local machine it works, when I run on the ...
Hi i need a ActiveX script to ececute a *.bat file through SSIS ActiveX Task.
any suggestion, would be helpful.
We need assistance in troubleshooting these errors we are experiencing on a consistent basis. For example, when we do a simple Select query on all the fields of the contacts table, I get the f...
Hi, I need a T-SQL Stored Proceduer defined for MS-SQL 2000
The purpose of the Stored Proceduer will be to subtract 1 (ONE) from a stored integer in a field.
Here's the complete scenario:
...
I am writing an MS Access 2003 application which needs to execute a DTS package on the server from a client machine.
The following code attempts to execute the LoadFromSQLServer method on t...
Hi ,
I am making use of DTS to export data from SQL ....
The data which is extracted comes out as
"middle_name","last_name","first_name","pri_phone_number","alt_phone_number","userid...
Is there a way in vbscript to detect if a file being copied from another server has finished copying. I would like to create a dts package using the activeX component to check if a particular ...
This probably seems like a dumb question, but how do I run the coperating system command 'COPY' from an Execute Process task in DTS?
I've tried:
COPY file1 file2
But I get an error "The s...
Yet another DTS first for me:
I want to transfer data from an Excel spreadsheet to SQL Server. Here are the issues:
1) All spreadsheets will be in a common folder.
2) The spreadsheets wil...
I have a SQL Server 2000 DTS job. I'd like somehow create a shortcut icon or similar for that job so I can put it on the desktop rather than having to navigate through enterprise manager each ...
SQL2000 DTS packages - is there any way to specify order of execution? Package is pulling down multiple tables from corporate - would like to have the largest table pulled last, but right now...
Hi All,
Please give example in SQL how to find duplicate records in:
Table1, where under one column duplicated records needs to identified.
Thanks!!!
How can I pass an Excel datasource name as parameter to a DTS package in which a data transformation service takes the Excel cells and feed them into a SQL 2000 table? The requirement is only ...
I am looking for information on DTSX...
1. How it is used.
2. Good sites to go to.
3. Good explanation on how it is used
