I have the DTS package as follows: Function Main() dim i_Day dim i_Month dim i_Year i_Day = Mid( DTSSource("Col002") ,7 , 2 ) i_Month = Mid( DTSSource("Col002") ,5 , 2 ) i_Year = Left(DTSSource("Col002"),4) DTSDestination("Col001") = DTSSource("Col001") if IsDate(i_Year & "-" &...more >>

Hello , I wanted to know how to make a dynamic FTP Connection. My FTP Server will be having a FTP server Name , File path, FTP Server Name, FTP User Name, FTP Password. Our Database maintains different FTP servers for different clients.In DTS we used below code in activex script ta...more >>

Hello, i'm using ssis on a machine with 2,8 Ghz, 4 GB RAM and more than 10GB storage capacity left on all disks. When I do a single click, for example opening a dataflow task or even click on it's border to change the label, VS 2005 reacts with a delay of two or three seconds. The whole G...more >>

Hi, i'm a bit confused about how protection levels, deployment and configuration fit to each other. I have sensitive data in my connection strings (such as passwords) and it's out of my reach to change this design decision. These info should be kept independent of the user accessing it,...more >>

I have created a SQL Server 2000 DTS package that exports data to an excel workbook. It runs successfully every time that I execute it from the DTS portion of Enterprise Manager. I created a job by selecting Schedule Package and when I attempt to run the job it fails on the first step w...more >>

Is is possible to sum data being imported in DTS without actually putting the data details on the 'hard drive'. I want to SUM fields on some incoming .TXT records. I don't actually want all the indiidual recods just the sums....more >>

I'm attempting to connect to the SSIS service on my server from my local workstation using Management Studio and when I try it I get: ****************************************** TITLE: Connect to Server ------------------------------ Cannot connect to xyz. ------------------------------ ADD...more >>

I need an example or some ideas - how to do this - I need to run a job that searches a directory every hour to see if any files are available for upload - and then upload it into a SQL data base - and then move the file to another directory. I know how to manaully upload the file using DTS...more >>

I'm rewriting all of our sql2000 dts packages in ssis for our upgrade. One of my packages has several ActiveX scripts. The script checks to see if a marker file is available and if it is, it proceeds to run the rest of the package. If there's a better (easier) way of doing this I am all for it...more >>

Hello, I created a DTS to copy some data from a sql server to another. I would like to use a global variable on a Transform Data Task with a sql query like " SELECT * FROM Table Where Id=? " in order to call the DTS with DtsRun.exe and put the value of the global variable on the command line....more >>

I'm new to SSIS and I'm trying to rebuild a sql 2000 dts package that imports a text file. This file has a field that is a string that is a date timestamp. The field looks like this: 20050622180517 in this format yyyyMMddHHmmss. In my sql 2000 dts, i use a date time string transformation to ...more >>

SQL2K SP4 Is there a way that an end user can exec a DTS Package from an application? I don't want to allow them xp_cmdshell or anything like it, so Im at a bit of a loss. TIA, ChrisR...more >>

Our application is used on both SQL 2005 and SQL 2000. Is there a way to copy a database from 2005 to 2000? I would like to start working with SQL 2005 and support SQL 2000 as well. -- Craig H. Anderson...more >>

I have a DTS routine that I have been using to append dates into a SQL Server 2000 table and it usually works great. It appends to a Smalldatetime column -- It is as follows: '********************************************************************** ' Visual Basic Transformation Script ' Cop...more >>

We have recently decided to migrate from SQL Server 200 to 2005. We have many processes built in 2000 DTS packages that pull data in from DB2 via an ODBC connection. Of course, the Migration tool is of no use in moving these packages to SSIS. How to I pull in my DW (DB2) data into SQL Serve...more >>

I need to: 1. Retrieve a subset of data based on data from each source record. 2. Perform some analysis on this data. 3. Set a value in the destination based on this analysis. I'm fairly new to DTS, but after a little research I thought I was on to something with the Lookup feature. After st...more >>

Is there any way I can zip up files within an ActiveX script? Thanks, Ninel -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200608/1 ...more >>

In our application, we would like to export the user data. In the main table, it is related to many other tables with foreign keys. We have not used DTS before and would like to see if it can export the data for us. How can we write a DTS package that will export from the main table, and all r...more >>

I thought picking the correct Provider would have been the easiest task! I need to connect to both SQL Server 2000 and 2005. I can't seem to make the correct selection among .NET, .NET for OLEDB or Native OLEDB. I thought that the correct choices would have been ADO.NET or Native SQL but now w...more >>

Hi, Sorry if I'm in the wrong group for this sql language question, but perhaps someone here can answer -- or direct me to a more appropriate newsgroup? I have a sql query that attempts to select a "DealerClientType" based on a Case statement involving values from other tables. Running the ...more >>

Hi, I am performing database conversion for a database of a 100 tables, each done by separate data transformation task. Task are ordered using precedence constraints. Is there any convenient way of diving tasks into phases (or groups of tasks) and choose on each exectution which phases to perfo...more >>

Hi there, I've planed the excecution of packages, some at different times, some others at the same time. Do you know how I can follow in real-time the execution of the packages with the start time, the current status....etc... Is there a native Microsoft user-friendly tool existing for ...more >>

SSIS 2005: Is there any other Best Practice than using a Lookup Task do an update via OLE DB for known IDs and doing an insert for unknown IDs afterwards to Update a table from an imported table? If doing so the updates are extremely slow. We used a staging table and a "update from where exi...more >>