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 >>