I'm trying to execute dtutil from xp_cmdshell within a SQL Script and then populate a log table with the results. The frustration I'm having is I only want to insert the actual result such as success or the error message it creates. I can't get around the rows that have the Microsoft info. An...more >>

I think I have a problem with the transmission speed of data when doing a DTS between two SQL 2000 SP3a server hosts running Win2K SP4. They have the same updated MDAC versions and I've conducted several tests, including running the SQL Best Practices tool to check server configuration parame...more >>

Server.MapPath in SSIS script task? I'd like to read a file (on the database server where ssis is running) into a variable inside my ssis script task. I have a reference to system.IO but get name 'Server' is not declared during compile, so I removed it. Dim FILENAME as String = Server...more >>

I made a batch file which runs an ftp script. I'd like to put this either into a sp. Not sure how to go about this. Here's the batch file: ftp -i -s:c:\laufer.txt laufer.com > c:\laufer.log It uses this laufer.txt The laufer.txt is: <User Name> <Password> ascii lcd c:\temp cd ...more >>

I have been looking to see if anyone has written a script to create the maintenance plans in SQL 2005. The previous commands like sp_add_maintenance_plan have all been depreciated. It appears Microsoft don't want you to script the creation. By having it scripted makes it easier to ensure the...more >>

Hi All, I apologize for the incorrect post. Anymore, Google performs miserably on Searching (btw, does anyone know what has changed in the algorithm for search results?). When I search for "script transformation editor" (with the quotes), I receive 1 hit - this group. What is the proper gro...more >>

I am attemting to move records from a text file into an existing table in SQL Server 2000. I only want to append any new records to the table, ignoring any records in the file that already exist in the table. But when I try to do this using DTS, it sees the duplicate key and just errors out. ...more >>

The below vbscript enumerates password age on computer accounts in Active Directory which is then output to an xml file. Then entry point on the ActiveX Task is Main(). This script runs fine outside of SSIS, but inside of SSIS as an ActiveX Script Task is generates the error: Package Valida...more >>

I am using the following VB.NET code to pull queries programmatically from an SMS Server and dump the output the an XML file. This data is later used in multiple ways, one of which is dumping to a SQL database. This runs just fine if run by itself, but I would like to be able to run all of t...more >>

Everyday I have to go to a website that displays a page of formatted text information, I then save the page using Save As...txt to a directory on our network. Is there a way I can create a SSIS/DTS package to open that page, save it as a text file and store it in a set network location? Tha...more >>

For the last three years we have been running DTS jobs by executing a stored proceder. We now want to upgrade our SQL Servers to Windows 2003 server on a more powerfull server. The DTS jobs will run manually but we can't get them to run using the stored procedure method. The error return...more >>

running DTSRun /S "servername" /N "package name" G/ "packageguid" /E DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecutePackageTask_3 DTSRun OnError: DTSStep_DTSExecutePackageTask_3, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Conne...more >>

Hello, I am trying to insert a row count into a log table after a bulk insert is performed. I have put in the Row Count transformation task, storing the value in a user variable, RowCount. At the end of the bulk insert, I am executing T-SQL, creating an index, other stuff, and then I want to...more >>

Hi, I'm a Newbie to DTS who needs to import data from an excel spreadsheet into SQL2000. When I use the import Wizard, the tables to be imported (sources) include all the pages from the excel spreadsheet as expected, however an extra source for each page is shown with the same name plus a $...more >>

I need to create a text file with data from a table. No problem, I've done that before. Then I discovered I need to select rows based upon a parameter. Still no problem, I know how to pass parameters to a DTS package with DTSRUN. I created a package with: 1) A global variable to contain the ...more >>

Good afternoon, all, I have an Excel workbook that needs to be imported. It has three sheets, but it's really the first that is giving me fits. Each of the three worksheets have header info and instructions on the first 8 rows. Worksheet 1 then has, on row 9, the column names for the group ...more >>

Hello!!! I am trying to build an SQL DTS Package which will export data from a table to a text file. The table has only one column and it ALWAYS has data. No nulls are allowed. The column length is 1500 but the data inserted are not always of that length. The issue is that when I export usin...more >>

Hi All, I found a sample of how to backup/restore a database .bak using sql dmo and have it working. Question on one thing, if I want to restore the .bak into a new database... What I did was to allow input of new db name, create new db using sql-dmo, and then use that db as the db to resto...more >>

Hi, From perf pointy of view, does SSIS has its poroper ressources when it executes packages or it is the same ressources(engine) used by SQL server itself. What I need to know is that when SSIS executes jobs in a package, lets say a select statement, does this operation is done by SQL engine...more >>

Hi, Is it possible to connect to 2 Flat files, merge the data and then in one operation send the data to one destination (table of a nother flat file).? if yes how? Also I am wondering if it is possible to have 2 data sources in one data flow Thanks in advance...more >>

Hi, I am trying to export data contained in a table on SQL Server 2000 to an Excel spreadsheet using DTS. The user is presented with a windows form to select the spreadsheet' s name and location. Once s/he clicks OK then the application runs the DTS package. Any help would be appreciated...more >>

Hi I have a job setup in SQL Server Agent (SQL 2005) that runs multiple packages. Each package is run as a separate step in the job. I am busy testing the job and want to skip some of the longer running packages for now. Is there a way to disable a job step and then enable it again when I a...more >>