Howdy, I scheduled a DTS task to run daily at 3 PM. How can I see this has been done ? Is there a place you can see when the last run happened ? -- Filip http://users.skynet.be/101airborne Official Site of the 101st Airborne - 463rd PFA skype: airborne463pfa-fiwi -----------------------...more >>

I want to import xml into varchar fields using SSIS, but the package designer does not allow me...I get an error... cannot convert between unicode and non-unicode string data Changing varchar to nvarchar in the table fixes that problem, but of course takes up more db space. Is there a ...more >>

We have a new machine with a fresh install of SS2k5. I restored some DBs from existing SS2k machines, but I need some of the old DTS pkgs. I've seen posts about migrating and KBs about restoring the msdb from one machine to another as a mean of moving the pkgs, jobs, etc., but these are n...more >>

Anyone using SSIS to pull data from Oracle is well aware of the issues associated with parameterized queries. I say issues, there really is only one - you can't create a parameterized query.... Anyway, I'm wondering if this is an SSIS limitation, or if any product using OLE DB as it's conn...more >>

Hello all! I am changing the collation on the database and doing a DTS package to copy all of the tables from one database to another. Can someone help with the script that can then (once DTS is done) compare row counts between the new and old database? Maybe just show the diferent tables o...more >>

We have an in-house app that writes to a Microsoft Access2000 DB that is password protected. This database sits in a directory on the server and there is no system.mdw file there. The application (its ASP) has no issues with connecting. I need to periodically pull one table from it to SQL (...more >>

I have SSIS with SP1 installed. I also have the Oracle 10g client installed. When I attempt to create a data source in an SSIS project for an Oracle database, testing the connection returns "error initializing the provider ... TNS error - no listener". However, if I create a UDL file and ...more >>

Hi, we exports a DTS-Package as a VB-Script to change the some servernames with search and replace operations. Now we should import the modified package (VB-Script) to the SQL-Server, but the SQL-servers dont't have any Visual-Studio-Software. It's possible to import a DTS-Package as a VB-...more >>

Hi, I've set up a new server, win2003 + SQL2000 SP4. No way to create or edit a DTS, I've got an error in the MMC: 1'st pop up: error creating a DTS (then ok) 2nd pop ub: impossible to open selected dts. DTS designer has been closed ( it's a french to english adaptation :) ) any clue ho...more >>

This is the code where I retrieve the value from the task '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Dim DTS, ExecSQL, SQLStatement Set ...more >>

I set up a package within another package. The inner package has a global variable, vartest, of which its default value can be manually changed from the outer package by clicking on the package task and then clicking Inner Package Global Variables. I set up an ActiveX script to try to pro...more >>

I have set a dtsx package with integration services. But when you want to create a job which execute package on sql server 2005, you lost all passwords for connection manager. You can set password for database connection writing the connection string in the connection manager tab. But for FTP...more >>

hi, i have to use a progress bar in vb.net to indicate the performance of dts package execution. For this purpose, the interval property of timer has to be set to the execution time of package, so how can i retrieve the execution time of dts package at runtime in VB.net. OR if some1 has ...more >>

I need to auto include yesterday's date into an emailed message TextBody. I've tried using getdate() but it didn't work. Is there someway to incorporate it into the function below? Help please? '********************************************************************** ' Visual Basic ActiveX S...more >>

Hello: does anyone know if the 'Copy SQL Server Objects task' is transactional? I mean, if i´m copying many tables data from one database to another, if the copy fails, the whole copied data will be removed? Thanks for any comments on this. -- JPortelaS. ..Net developer...more >>

Hi all, I have a table w/ 50 mill. rows. I need to update 2 columns. The table looks like: patientrcd# patient# facility subtitle datetime page ------------------------------------------------------------------- 0202013 23432 B 05/17/0402 NULL 1 ...more >>

using SQL Server 2005 I have a package variable that I want to map to a parameter that I'm using in the WHERE clause of a SQL statement. I'm getting this error on the Data Flow task when executing the package: 'Value has not been set for parameter 1.' How can I map that parm to...more >>

Looking for a utility or tool to migrate 1000 dBase or Clipper files into the SQL Server 2005 Express Edition Environment. ...more >>

Hello all, I have a problem that I am not sure how to go about solving. I know I could do this fully in code but I want to do this in a DTS Package I wrote. This is the scenario. I have a table that has a varchar field called AdditionalSQLOrParameters. In the field some of the records ar...more >>

Hi, I want to retrieve some data with the activeX script task, but I always get an error when I want to retrieve a field from the recordset and point it to a local variable. -------------------- dim countr dim Budget set mySourceConn = CreateObject("ADODB.Connection") set mySourceReco...more >>

Hi all, I have many DTS jobs that copy files to my SQL server and import them into SQL tables. Is there a way to get a list of all jobs and what files they are accessing? TIA, Joe ...more >>

In good old DTS I could set a transformation with no inputs to feed a destination some dafualt values in Activex script using the syntax: DTSDESTINATION("ColumnName") = text Is there a way to do this in ssis? ...more >>

I have created a Stored procedure which is executing right in query analyser but if i put the same stored procedure in the DTS to execute ,Data transformation task it is giving me error as "ADO ERROR : Invalid Object Name #tempEmp " In this stored procedure I have created Temporary table #t...more >>

Hi All, I am trying to run a dtsx from the command line and pass a value to a user variable. Anyone know how to do this? Cheers Mark...more >>

I am trying to execute a batch file from the Execute Process DTS task. It runs fine, but everytime I log off Enterprise manager, stop MSSQLServer or reboot, the Execute Process task loses it! I have to open its properties and repoint it to the batch file in question every time! Others are comp...more >>

Hi, We're trying to build a new datawarehouse using SSIS. We've addressed several entities that we need to load. A lot of these have to go through exactly the same steps. So i would like to build a generic SSIS package and use a variable for each entity that I need to load. I've noticed that ...more >>

Hi All, First of all I would like to say that these newgroups are brilliant for support, thanks to all that has contribute to any my previous questions in the various forums. Now to my new problem. I have been working with SQL Server 2005 for the last few weeks, and have now created a new ...more >>

how can i export table from sql to Excel using OpenRowSet function ...more >>

I have a dts package that is scheduled as a job. This job is created under the admin ownership. The job is failing even when I log into the server as an admin and start (execute) the job. If I execute the dts package itself it runs successfully. Any ideas why this may be? Thanks, Ninel --...more >>

Hi, I am creating a bulk insert package and I generated a format file. I selected (checked) first row has column names but when I import the data it import the column names to the table. Why? Pleas assist. Thanks...more >>

I tried adding a Data Flow Task control to my BI project and got this error when trying to rename it: TITLE: Microsoft Visual Studio ------------------------------ Could not get value for property 'a8905386-80fc-478b-86a3-ae9f5c001815'. Specified cast is not valid. --------------------...more >>

Hi, I'm fairly new to DTS and am trying to copy the results of a query to a text file but get the following error: Error creating datafile mapping: The volume for a file has been externally altered so that the opened file is no longer valid. I'm using sqlserver 7 and have created a connec...more >>

I have a data pump task which uses a csv file as the source, and a db table as the destination. I have set up transformations to map the fields in the source to the destination. However...if the order of the columns in the csv file is now shuffled, but the names of the re-ordered columns are s...more >>

Hello NG, importing a DTS package that has been saved as a structured storage file is easy, if the SQL Enterprise Manager (Right click on 'Data Transformation Services', 'Open Package') is used. It does not seem to be so easy, if this activity needs to automated. I currently use the ...more >>

Hey guys, I am very new, ie 1 hour so far, to DTS. I have succeeded in creating a DTS thing which takes a csv file of projects and imports it all into a temporary table in SQL Server. What I wish to do, for say the Client column, is cycle through all the rows and check if there is a clien...more >>

I'm trying to pass a parameter of type int to a SP by using ? in a OLE DB Source. I have selected "SQL command" in connection manager. The command is as follows: EXEC PromoPoint.dbo.Load_PointsHistory ? In the mapping options, Prameter0 is mapped to a User::RunId variable which is of type in...more >>

We have upgraded to SQL Server 2005 recently and I am in the process of migrating the DTS packages to SSIS. I have resigned myself to the fact that the creation of SSIS packages is more difficult and complicated, but that this hopefully is made up for by having a more capable and powerful t...more >>

I set up one DTS job to run for two different groups. There are some tables which should not be loaded for one of the groups. For the stored procedures, I pass a parameter and then based on the parameter the stored procedure executes the required code. For the data transform tasks, is the...more >>