Hi All, I have a .NET assembly that needs to be called from a DTS package. There are two options I am considering to get this to work: 1) write a COM-callable wrapper for the .NET assembly and have the VBScript create the COM object to use 2) write a .NET command-line exe that uses that .NET assembly and have the VBScript execute tha...
I have scheduled a DTS to run from a scheduled job. The DTS has several steps in it. Now whenever the job is running and I take a look at the jobs section in Enterprise manager, then it always displays the following in the status: Executing Job Step 1'.... although its running all steps properly. How do I know at what step the DTS is run...
I am using timestamp as new folder name. Seems like if the folder is not exist, the file won't save at new path. Can the community advise how to create folder with ActiveX script? Thanks. ...
I am trying to get the DTS Step Name/Description of a given DTS Package in SQL2000. I am not able to see anything in the msdb database. I can see the initial DTS name, however I dont see anything to get the details. Anybody knows where this info is stored? ...
Hello! Our company currently implementing TSA (Time Stamp Authority) service. And now we are searching CA (Certification Authority), which could issue certificate with intended usage: Timestamping. I contacted with few CA's, but they offer just Digital ID certificates, and know nothing about TSA. Maybe someone has experience with such p...
Tell me please what's the best way to copy db structure to another server? I'm trying to generate a script in Management Studio and then run that script on the remote machine. And I hate that thing. It works unpredictable, you have to fix manually a lot of crap in the generated script. I guess that isn't the best solution. Then I tried...
I have a DTS package on SQL 2000 that I haven't touched for three years. Package is running without problems every night and now I need to make some changes. Package reads data from couple of Access files that have password set. When I open Access connection in DTS designer and click OK I get error message "not a valid password". Why...
The company I work for has a lot of systems where the source data originates as a flat file or Excel workbook. These files are then imported using DTS into a SQL Server database. Quite often these files contain various control characters (for instance I've just spent an hour finding that some records have a \0 in them which apparently S...
I need to migrate the DTS (SQL 2000) package into SQL 2008 SSIS. The DTS package is using HTML file data source and a Transformation task to import the HTML table into the SQL table. I didn't find the HTML data source in the Connection Manager in the SSIS designer. Does this functionality exist in the SSIS ? Thank you. ...
I've to document a bunch of SQL Server 2000 DTS, is it possible to export the DTS definition in text format? Thanks. Han ...
Dear All, I have written a task script using vb.net that have thread used in the code, the problem is how i can know when will be finished all the threads so i can return the success result. Thanks alot. ...
Have a DTS package that is running in Development, SIT, and UAT. All of the SQL Servers in each of the environments has the same linked servers setup and are the tech specs similar. The DTS package takes different amounts of time to execute. The package should take about 3 hours to run. There are indexes on the tables that are access...
In SQL Server 2005, Import Data (SSIS), my desire is to import a text file and have it append to an existing table. The first time through the wizard on the Column Mappings step I swear the Append rows to the destination table radio button was enabled. But, now, it's disabled (grey) and even re-starting the wizard won't cause it to re...
Hi, Is there a way to stop a SQL Server 2000 DTS (not SSIS) package that is currently running, programmatically using C#?. I think the package can be executed using the COM API, but I couldn't find a way to stop a running package. thanks in advance. Update: there is a method in SSIS to get a list of running packages and a method to stop...
We have a VB.NET (.NET 2.0) windows service application that uses SQL Server DTS to send data to a central server. To access the DTS, we install Microsoft SQL Server 2000 Desktop Engine (MSDE) and then reference the DTS COM component. We can then use then use DTS from within our service: Dim m_pkg As DTS.Package2 m_pkg = New DTS.Pack...
Hi, my requirement is as follows. the SSIS and DTS packages are stored on the webserver (not in database) and I need to execute them on click of a button on an ASP.NET web page and be able to abort them (again by user action) if they hang for some reason. user doesn't have access to sql server management studio or enterprise manager. if ...
Hi everyone, I have a basic/simple need to create a pipeline transfer process from one SQL express 2008 database to another server (equally SQL 2008 express). Basically: I have one table on SERVER A which has data coming in, and a default field called 'downloaded' which is again, by default set to 'N' I have the same table schema on ...
Hi, I have a DTS package, which after running daily with no problems for a couple of years, has started to play up. Originally it was inserting data into a table which would then fire an insert trigger. The trigger used [inserted] to update three columns in the table. Usually, it was updating about 500,000 rows of inserted data. When t...
I'm sure that this is a pretty vague question that is difficult to answer but I would be grateful for any general thoughts on the subject. Let me give you a quick background. A decade ago, we used to write data loads reading input flat files from legacy applications and load them into our Datamart. Originally, our load programs were wr...
I have source server and destination server, i have insert the data from source to destination, but before that i have to delete the records if any in destination - (DTS) ...