So I have two identical SQL 2005 databases, one on server #1 which is the back-end for my Production site, and one on server #2 which is the back-end Training site. I have had a number of new...
On a Windows 2003 server there are mutliple errors in the event log as seen below. If I open component services under administrative tools then expand Computers, the My Computer icon has a red...
The following code works with VB 6.0, but it does not work with VB 2005.
Dim oTask As DTS.Task
Dim oCustomTask1 As DTS.DataPumpTask2
oTask = CType(goPackage, DTS.Package).Tasks.New("DTSEx...
I need to create a DTS package using SQL Server 2005 in order to move data, not the spreadsheet itself, from an Excel spreadsheet that is located on one server into an Excel spreadsheet on a d...
I'm using SQL 2000 Enterprise Edition and I'm trying to use the IMport / Export wizard to export the contents of a table to excel "but" I need this process to over write the spreadsheet and no...
Hello ! I'm getting some .dat files and when i try to open these files with notepad looks like this:
02154 Mike 8594 08/05/2004 66
02155 James 8766 08/05/2004 01
021...
I have a DATE_OF_BIRTH field that is imported into my database. It is a Varchar 50. I have some SCRUB related statements in a DTS package that I execute after the data is imported. The SCRU...
I have a DTS Package that runs a stored procedure which creates a table (dbo.TT_RAW_CASE_DATA) in the db and then outputs the contents of the table into a .txt file. My problem is that everyt...
I need to export some tables from my SQL Server 2005 to Access using queries in order to filter data that I want to export. I can use Visual Basic if it is necesary.
We have used an old photo archiving program, Image Access Pro, to record our extensive photo collection. The company making the program sold out 5 or 6 years ago, and so is unsupported. We a...
The first thing I need my DTS pkg to do is to check whether the files it's about to pull from our FTP server have the current date. (I can already use VBS to check file properties after they'...
Hello Everybody.
I recently got a request to develop SSIS package that downloads a copy of file from FTP server based on creation date.
I found an sample script code for the task from MSDN f...
Hi all, I have a DTS package that runs fine at times and not at others. Problem seems to be that the system is trying to go on processing the file when it hasn't finished opening it (it is a ...
Greetings all
I need to create a DTS package to run on an Sql2000 server. The package must import a CSV file (BranchId, Year, Month, Amount) into a table. I need to check that the CSV data ...
Hi All,
Is there a way to use the Fuzzy lookup in Standard Edition of SQL Server.
We require this functionality in our SSIS, but we have a constarint of having Standard edition of SQL Sever ...
Each time i tried to start my sql server i got this message error
Error # 1068 & # 9003
any help
How to export multiple tables to a single flat file?
Is it possible to export n number of tables to n number of files at once?
Hi Experts,
DTS today failed with error below. It has been working fine until today. Can someone please advise to resolve this error.
Step 'DTSStep_DTSActiveScriptTask_1' failed
Step ...
I am trying to use MS SQL Server's DTS package to import a MS Excel spreadsheet into a database. I am using MS SQL Server 2000 Enterprise Edition and MS Excel 2003. There are several problem...
We have a WIndows 2003 / SQL 2000 server that handles the vast majority of our ETL processes. Every once in a while, all of our jobs will seem to hang. When reviewing the output of sp_who2, ...
I need to import some excel files in the Database via DTS. The problem is, that I don't know the names of the Excel Sheets (there are multiple sheets in the excel file). Is it possible to get ...
I have a DTS in SQL Server Enterprise Manager that runs and gets records from an Oracle database and moves them into a MS SQL database. Then in FileMaker, I have a Script that IMPORTS RECORDS...
Using SQL 2000, I need to:
* Get data via a stored procedure
* Write data to a text file that has a unique name ("Filename + date".txt)
* FTP this text file to a remote server (ftp://ip.add...
Hi all.
I have a stored procedure provided in the code snippet. When I run it in my ActiveXScript in my DTS:
oConn.Execute = "[SDI].dbo.spDelay '0:1:0'"
While testing it, it works fi...
I am trying to write a vbscript to access the execution_status of a sql server Job.
I have a Job named "Import Food Establishments"
I have a vbscript I just wrote that performs the sp_start_...
