Hi, I am in the middle of creating a dts in SQL 2005 which needs to push data to a MySQL database. I am able to create a datasource connection in solution explorer and then add it to the connection managers, but am struggling with setting the connection in the 'DataReader Destination'. T...more >>

Hey i am planning to use the BULK INSERT to copy the data into my Server. The data is being written to the file by external application. But i want the data that is being written should be deleted after the insert. Can BULK INSERT statement support such option to be specified. other wise...more >>

I have column in the destination table that does not allow nulls. I have a lookup table to grab an item's ID. If the item doesn't exist, I simply want to skip this row. Sounds simple, but I've been pulling my hair out for the past two days on it. No matter what I do, I cannot trap the null a...more >>

Hi, The following code works perfectly but now I want to do a little tweak at a different part of the DTS package. What I want to do is to delete files that are blank so they are not FTP'd to the remote server (a zero byte TXT file). I can see in my head what I need to do to the code, but I...more >>

Hi ppl! I want to get the type of task from a task object. In the package I have an Execute Package Task and an ActiveX script task. In the ActiveX script task the code looks like this: For Each oTask in oPkg.Tasks MsgBox oTask.CustomTaskID If oTask.CustomTaskID = DTSEx...more >>

I have a xml data file, I want to use DTS to convert xml data to MSQL table. Is that possible to design? ...more >>

When defining a Data Source in the DTS Import/Export wizard, my local SQL Server instance, Developer's Edition on XP SP2, is not showing up in the Server drop down. 'Microsoft OLE DB Provider for SQL Server' is selected in the Data Source drop down. I'm certain it was there yesterday; I pushed...more >>

Hi I have created nice DTS package and saved it as .BAS file. How can I customize and execute it now from C#.NET? I have found on the net that I have to create custom task. I have customtask.dll, now I should implement something new there or I can just use it? Can I set properties from there ...more >>

I have designed a DTS package and have enabled SQL Server logging in the properties of the DTS package. Since this is writing to the msdb, does it just keep on writing? How do I specify how long I want to keep the logging information around in the msdb? Thanks, Kayda ...more >>

What is the best way to export a table from one server to another server... The first export will have to be a full export, however I want the subsequently scheduled dts exports to be incremental. Thanks! Clint ...more >>

Function Main() Dim FSO Set FSO=CreateObject("Scripting.FileSystemObject") FSO.DeleteFile "C:\MSSQL\ExLogFiles\*.*" End Function Dim test test = date() path = "C:\MSSQL\ExLogFiles\" set fs = CreateObject("Scripting.FileSystemObject") set folder = fs.GetF...more >>

I know how to loop through one set, but wasn't sure if there was an easy way to loop over two variables, something like: Get list of servers Get next server from Server recordset --a For Each Server Get List of Databases Get next database from DB Recordset --b For Each Database on server...more >>

Hello, I've created a DTS with 2 data sources. Now I wanted to rename one of the data sources so I have to create a new one. How can I delete the old DS? (It appears in the object's list) Bye ...more >>

Here's a weird one, but I'd be more than grateful if anyone could help. I've been given the task of recreating a DTS, the only problem is when I try to view the contents of the DTS, I see nothing. When I try to create a new DTS, I get an empty window with no icons on the left (when using SQL...more >>

Hi, I am currently using the LoadFromStorageFile method i.e. myPkg.LoadFromStorageFile DTSPkgFile, "", , , DTSGlobalVariables("UploadSubPackageName").Value which works great, however I would rather use the LoadFromStorageFile method but get various security errors - any ideas? Thanks Paul...more >>

Hi Friends, Can can any bady help me to call custome task here is small snipet CallSP("EXEC USP_DeleteReportingRecords 'Month To Date Half Hourly Report', '07/15/2005'") Function CallSP(Strsql) Dim oPkg Dim oExecSQL Dim objTask Dim sSQLStatement set oPkg = DTSGlobalVariables.Pare...more >>

Executive summary: How do you create a DTS connection in vb.net 2003 code to an Excel spread sheet? Background: I'm creating an Excel to SQL dts package from scratch in code for an SQL 2000 server in vb.net 2005. (Don't ask - I'm a programmer. I write code.) SQL Enterprise Manager makes ...more >>

Hi, I'm trying to view a database using Enterprise Manager and am getting the following error when I try to view the list of tables, stored procs etc: Error 229: SELECT permission denied on object 'sysobjects', database 'tours180805', owner 'dbo'. SELECT permission denied on object 'sysinde...more >>

Hi, I'm trying to create a DTS package that creates several cvs files, zip them one by one and then email them all in one email. I have to cvs files that is only supposed to be created once a month and I'm trying to get the DTS to skip that step if it's not the first of the month. I tried ...more >>

I have a DTS package which concatenates 3 columns of a table and exports this final column into a flat file. I need to add a final register to this flat file (the number of registers on the file which is the last last row of the column) how can I do this? Also I need to ask the user for a dat...more >>

I would like to be able to right click on a DTS package in windows explorer and have it open in DTS Designer? I'm using Sql Server 2000 is this even possible? I know that you can configure associations with a program, but I need help with the open in DTS Designer part Any ideas? T...more >>

Can the Bulk Insert Task in DTS be used with the FIRE_TRIGGERS hint? If so, how? Or do you have to use an Execute SQL Task with the Bulk Insert T-SQL command. *** Sent via Developersdex http://www.developersdex.com ***...more >>

I am getting the following error, Invalid procedure call or argument: 'DTSDestination' I have the following code, If DTSSource("Complete") <> "" Then DTSDestination("Amount") = DTSSource("Complete") DTSDestination("Complete") = 1 Else DTSDestination("Complete") = 0 End If M...more >>

Could someone tell me what this error means? What is the error number to this dts package error and where do I find the full description of the error? I could not find anything under sql server books online. I got this error message while running a scheduled DTS package job: DTSStep_DTSA...more >>

Hi, I need to execute a DTS package from another computer in my network which has no SQL server installed. HOw can I do this? *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have a parent DTS from which in call several child packages. When adding an Execute Package task I get asked for the SQL server name in order to browse the packages. I then select the appropriate package name. My question is about copying the packages to the production server. I see a pa...more >>

I've a dts that needs an explicitly defined argument. I'm looking for both some kind of interactive 'input box' that lets the user type the needed argument and some kind of launch parameter similar to the ones that EXE file get. I'm not interested in ini-files parameters. Thanks in advance...more >>

SQL-SERVER 2000 Hello - I want to import data from a paradox table. In this pdx table I found 2 fields: one for Date defined as pdx Date datatype and one for Time defines as pdx Time datatype. I cannot change that. I built a DTS - which fails on the Time field (defined as SmallDateTime in the SQ...more >>

hi all, I want to use ini files to store server details, but feel that storing server username and password in ini file is not secure. Any suggestions? regards, kshitij...more >>

I have a package that executes just fine when i select 'execute' When i go to schedule it, the corresponding job is created. But when i run the job, it fails. It says: "Cannot connect to the Analysis server on computer 'ENG1SQLV1'. Connection to the server is lost Error source: DSO" ...more >>

I have to move tables of aproxximately 15 million and 1 million records, would either replication or DTS able to do this for me? What would be the best practise to move this amount of data across the internet using dts/replication? Thanks in anticipation. Ajay ...more >>

I've created a DTS that gets data from a foxpro source into a SQLServer destination. The DTS runs perfectly fine through the Enterprise manager, and infact works fine on the command line, but when I try to initiate it through a Stored Proc (I use : EXEC @result = master.dbo.xp_cmdshell 'dtsr...more >>

I have a DTS bulk insert task that is behaving oddly. It runs and indicates that it ran successfully; however, upon examination of the data in query analyzer, it is clear that the data loaded fine BUT only 1194 of the 504,000 rows loaded. No error message or other messages are received. The ...more >>

How can I move a package from one server to another?...more >>

When I use the DTS wizard to import data into a SQL table only 3 out of 2050 records are imported and I get no error messages. When I select the SQL table of the same name with a $ on the end I can preview the first 100 records and the import seems to succeed and show 2050 records are importe...more >>

I don't want to change anything in my DTS when moving from DEV to UAT to PROD. So, I have an activeX script (see below) at the start of my DTS that looks for a DTS.ini file in the same folder, gets the path & then sets the SourceIniFileFileName. - this works fine when the DTS is executed with...more >>

How do I set the datasouce to dynamically change to the server it resides on?...more >>

How can I run a DTS package from a network client computer? When running, will the error messages show as it does when running in the SQL server enterprise manager? *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have created several scheduled jobs a few update some tables while the rest are the Backups, made with the DB Maint. Plan Wizard. The ones that updated the tables will not work while I am sitting at my computer but they will if I am working on the server. I am using remote desktop when worki...more >>

is there a procedure for recovery of dts packages of a crashed server? I have a colleague who was developping a dts package on a test server off course, the inevitable happened without a backup at hand where can I find the DTS packages and how can I get them back PS: it was a diskcrash with ...more >>

I am trying to get into SSIS I am not a developer but a complete newbie, I want and need to bring together data from different sources for reporting services, score carding and anaysis services ect for our company I am managing to move data from a to b ok however this does not cover all the task...more >>

Hi, I'm trying to create a DTS package using a Transform Data Task using the following query: "Select field1, ? from Table1 ". I want to pass a parameter inside my select query so I can populate the destination with the parameter that I'm passing. Is it possible to pass a parameter inside...more >>

I am writing a DTS package that gets executed remotely. The remote exectution passes a value that populates the global variable of the main DTS package, MainVar1. There are several other variables in the package that are dependent on MainVar1 variable. What I am trying to do is concatina...more >>

sql2k sp3a Dont know if "invert" is the right word, but the only one I could come up with. I have a flat file that displays data like: GEN_PROREGCTCTXT CRZCODE S_GENERATION 1 CB 1 1 CS 1 That top row is data, not column names FYI...more >>

I have a simple workflow that executes three tasks and in the final task I have a success branch and a failure branch. The final task is a sql statement to delete rows in the table. I intentionally misspelled the column name and saved the package. My thought was it would go to the failure step...more >>

I'm trying to run a very simple DTS package using DTSRun command line but keep getting a cryptic error that has stumped everybody in-house on three continents. The DTS pacakge (really just a test) simply inserts one record in a table. The paraphrased command line is this: DTSrun -s MySQLServ...more >>

I have a Source and a Destination with the exact same structures. The information in the Source Table for a given Key (example Customer) replaces all of the information in the Destination Table for the Key. Is it more effective to create a task to delete all the records for the customer in...more >>

I am modifying a DTS package that had an existing ActiveX script. When I try to execute the DTS package, I get the following error when the package tries to execute the ActiveX script: "ActiveX scripting was not able to initialize the script engine" Why would this happen? Thank you, ...more >>

While using the SQLServer DTS package. If I use Datapump to insert data from text file to table into a single column will be faster or into a multiple columns will be faster. If I insert data into single column, then I need to write a sql script or procedure, use string operations to split th...more >>

Hi all, We've created a VB.NET application which runs a couple of DTS packages on a SQL Server in a specific order using ADO.NET. When we runs this application on the same machine that SQL Server resides on it works fine. However when we run the application on another machine in the domain ...more >>