Hi, I am very new to working in DTS and offcourse IS in Yukon.Can any one suggest me the start up in transforming data from CSV file to SQL Server database using SSIS in Yukon. The UI Navigation details for the same and what kind of programming is involved etc.. As started with Business ...more >>

I have a DTS package that defines a Dynamic Properties Task, which in turn has 2 destination properties each of which define a data source generated by a SQL Query in an attempt to generate dynamic file names for 2 flat files based on the date/time. When I have the package open and execute...more >>

I am converting our old DTS packages to the new SSIS packages in SQL server 2005 integration services. I must apologize first, becase I am quite a newbe at this SSIS, so hopefully my question makes sense for you. In DTS, I had a data driven query task that would use a select statement, to ...more >>

I've created an ActiveX Script within a DTS Package in SQL Server 2000 that exports data from a database table into an XML file. It works great, but now I'd like to filter the data to only include data where the "item_date" field is before today's date. (i.e. item_date = 2005-11-30; today_date...more >>

I've installed SQL Server 2005 both on my desktop system and on a Windows 2003 server. I'm wondering why the "flat file source" selection is available in the list of import data types on the server but not available on my desktop system. Most of the selections are the same in both cases but th...more >>

I have a DTS package which checks for files in a designated folder, and imports the ones it wants. However, if no files exist it just reports an error, and the package fails. Although this is what I want, it is untidy. Can anybody suggest how I can add workflow 'If no files exist, stop run...more >>

In the activex of data pump task, I need to apply a same function to every source column to get destination column. Is it possible to write a for loop to apply the same function to every source column so that I don;t have a repeat the following code for every column. DTSDestination("col1") = A...more >>

We would like to upgrade to SQL 2005, but we have customers who use DTS on SQL 2000 to pull data from our database. Will we have problems? -- Jay Croft Senior Systems Architect...more >>

I'm all for progress but I miss the simplicity of 2000's DTS. All I want to do is copy a source database to a destination along with that sources, structure, data, indexes, relationships... It was a single dialog box with some option buttons in 2000's DTS. Now, the Export function transfers on...more >>

Guys, Today I have a SQL2000 DB running on a Windows2003 server. I wanna move this DB to a new Server where I also have Windows 2003 Server, but in this new server I have a SQL2005 version instead SQL2000. My question: Is there any tool or Function on the SQL2005 like Attach/De-attach that I ...more >>

Good morning, I have a 2003 AD domain with a SQL2000 dedicated machine (server). I try to export on a windows 2000 server (excel or txt files) from my sql db. As I am runing my DTS myself, everything is ok... If I use the SQL planer, it does not work giving me an error 80004005 with acces denie...more >>

Hi, I'm try to upgrade the SQL2000 hardware, how can I copy all package to the new machine? Thanks, ...more >>

Trying to use the DTS Wizard to Import data from one table into another. The problem is that the source table has DateTime data and I have to fit it into a VarChar column. The problem is that the DTS Wizard is changing the format of my data so that source column data 12/30/2005 becomes 2005-...more >>

I can drag and drop the Send Mail task in a dts package and use it to send mail to a specific person and it works. The question is, how can I use it to send multiple emails to various email addresses using a select from a table? Anotherwords, how can I do a select from a table and use the resu...more >>

What needs to be instlled on the SQL Server to enable a DTS package to use SQL Mail? I gotta use an SMTP server on another box to send out SQL mail, so it needs to be able to send the mail to an SMTP server. I understan that if you have a mail client instlled on the server, that this will allo...more >>

Does SQL 2000 workgroup edition support DTS, Data Transformation services...not user interface, but be able to the source or target of the DTS package? Thank you, REF (Clayton Halvorsen)...more >>

Hi all, I have a main DTS Package (SQL Server 2000) that executes another DTS Package (with Analysis Services Processing Task) with Execute Package Task. When I execute the main package (click in the green arrow inside design package window) it hangs up when executing the Execute Package Task....more >>

I want to upload data into 5 dimensions in my Analysis Services database. I do not want to update the dimensions during the cube processing I want to build and process the dimensions seperately from the cubes. I use the analysis services DTS task to load data to a analysis Services cube how c...more >>

Hi, I am observing a strange behaviour of an SSIS package I created: - It reads from a comma separated {CR}{LF} line terminated flat file into a SQL 2005 table. - the file contains 19636 rows. When I run the package, there are no errors, all rows get imported and a short at the imported dat...more >>

I built a custom component (con. mgr.) that uses some external dependencies (dlls) and properly registered it with SSIS. When I open up BI studio, create an IS project and bring up the Package designer (and do all the other required stuff to make it actually visible in the Toolbox) I can see m...more >>

....than the domain assigned to the SQL Agent Service account. For example, we have an account XYZ\SQLServiceAcct that is shown as the owner of the particular SA job and is also the account running the Agent. It is reflected in the message text related to several of the job steps, but not all ...more >>

How can I transfer DB diagrams and referential integrity relationships between databases with the same structure. I copied dtproperties table from one DB to another but it copies diagrams without foreign keys. ...more >>

Hi I have a WinForms client which needs to execute a DTS Package on SQl Server 2000. The Sql Server db is on a server. If I run the client on the server it executes the package ok, however If I run the client from a remote PC, the OnQueryCancel event gets fired before the execute and the the ...more >>

I would like to know How I can automate an DTS and How I can publish an Cube with OWC 2003? or I need other tool for this issue?...more >>

Hi I have quite a strange DTS problem. I wrote a script to load data from a Excel spreadsheet into a Access database. If I run the script (doesn't matter if I run it from Enterprise Manager or with vb code), it just skips some rows from the source file. The rows in the spreadsheets are always...more >>

Hi, I am using SQL server 2005 (Ver:9.0.1116). I am unable to find how to create a DTS package from Sql Server Management Studio. It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio. I want to know how to start a Integration services in Yukon. As,the...more >>