Hi,
Every day we will receive orderfiles which are PGP encrypted. I will download them from a FTP server using an FTP scheduler and then import them into our database using a dts package.
...
I migrated one DTS package from SQL 2000 to SQL 2005 through Migration Wizard. It's migrated successfully. I didn't know where migrated DTS package located, and didn't know how to run the DTS ...
Hi all,
I get the below error. There is no row at position 0
at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
at System.Data.RBTree`1.get_Item(Int32 index)
at System.Da...
Hi Experts,
I have one package with several shapes.
This package should be executable for different countries.
That means e.g.
There is a Data flow shape with a flat File Source and a ...
I am running a 2003 Server with SP1 on a Domain
I have a MS SQL 2000 SP4 Job failing and it gives me the follow Error in a text log:
DTSRun: Cannot create COM Server to load and execute D...
I have an activex step which i will determine if a file exists. If the file does not exists then i return failure else success. if failure i have a workflow link set to go on to another step "...
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.
...
hey there
i have an access Db that i down-sized friom an SQL database. the export did not maintain the autonumbers in the database tables.
i know that i cannot swuthc them onto auto numb...
Hi,
How to create CVS file using SQL 2005.
The scenario is: I have a C# .Net ASP 2.0 application and it is a executable file, when this executable file runs it generate a XML file. I have to send this XML file to a ftp site every hour....
I have a table with a field called LNFN. What query would I use to find all records where the LNFN's are the same? In addition, I need to create another table with all duplicate LNFN's (the en...
Several DTS packages that take SQL tables, converts to access data by dropping the access view, running a SQL script and copying over...
Can't figure out how to copy those over to run against...
Hi Experts,
I'm trying to run a DTS script that copies tables to from a dev server up to a live server. The DTS script works fine with a right click and execute.
I've been using these t...
Hi Experts,
I have to move access 2003 db into SQL 2000 db and create a DTS package which perform in the same way as Access modules are doing
Access db ...
Hi
In SQL 2000 I have this DTS wizard that writes the content of a table into a file.
(Data transformation services -> export data)
The DTS asks for the filename to use...
Now I want to...
I am trying to do a DTS, with the Enterprise Manager from Sql Server 2000, to get informations from a table located in a Oracle database to fill a table located in a SQL database. I've done t...
I have a SQL Agent Job in SQL Server 2000 that uses a DTS Package to import information from an ORACLE source. This is a direct import with no special transformations. I have this job schedu...
Hi Guys,
I current have 418 delimited DAT Files that come through nightly as a backup from one of my systems. Of these 418 files, I manually DTS in 50 of these a week. I have attempted to s...
Im writing a DTS package which goes through multiple steps of importing data. Im looking to write to a single log file for the process. Using the wizard tools I can write to the file howev...
I am trying to replace the NULL values from my data source before the transactions are inserted into my data warehouse. I want to replace the <NULL> values with a string that actually says NU...
I've recently upgraded to SQL 2005. Using the legacy tools, I have a DTS package that I made changes to. Now there are multiple versions of that DTS package. In 2000, you could just right ...
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...
Bit of a conundrum here. SQL server management studio has a generate scripts function that allows you to script any operation that it performs, except one. It doesn't offer the ability to scri...
I have an ActiveX task in a DTS package (SQL Server 2000) that is building a .cmd file that I wish to then execute from within the script. The code I have is shown below. The data shown in th...
Is there a way to have the [DATE] function in DTSRun to only give me the month?
I need to have the [DATE] function in DTSRun to give me the the month only.
What I have is this:
DTSRun /S ...
