Hello, I am using DTS to convert database from Sybase to SQL server. I am using a active - x transformation to convert table1. Under...

Irene

01-08-2007 06:31 PM
Irene

Thanks again Tibor. I had looked in SSIS at the package and it had mentioned the Reader Role as db_dtsadmin, db_dtsoperator and the creator of the...

Chris Wood

01-08-2007 04:58 PM
Chris Wood

This is a DTS NG so you will be better asking this on an AS Group You can have multiple partitions in AS all with a query to isolate the data...

Allan Mitchell

01-08-2007 04:53 PM
Allan Mitchell

I am using DTS copy sql server object task to copy data and objects from one server to another. The job has been failing with the following error....

Subbu

01-08-2007 03:28 PM
Subbu

Something like this works for me. Sorry it is in C# but it is easy to convert Microsoft.SqlServer.Dts.Runtime.Wrapper.Application app = new...

Allan Mitchell

01-08-2007 02:11 PM
Allan Mitchell

Hi, I am a new comer in SQL Server DTS area. Can you please explain me what the fuctionality of "Dynamic Properties Task" with some real...

arijitchatterjee123@yahoo.co.in

01-08-2007 01:37 PM
Allan Mitchell

hi! I have a DTS package in which I am running validations on claims. If they pass they get inserted into xstaging table, if they don't they...

TG

01-08-2007 01:33 PM
Allan Mitchell

I have a DTS package using ActiveX to scan and record various properties from one or more DTS packages. As part of this, i want to retrieve the...

Jim Trowbridge

01-08-2007 01:29 PM
Allan Mitchell

I have a deskop at a client that does not appear to have the Expression Builder installed. There isn't an elipsis for the builder on the...

Ken H

01-08-2007 02:05 AM
Ken H

Has anyone seen this before? Anyone know how to fix it? I'm getting pretty desperate and have found no info about this on any of several web...

Tom Murphy

01-06-2007 06:08 PM
Tom Murphy

Hello, I am new to SSIS. I am trying to write a simple package to export data from some SQL 2005 tables and into a flat file. In my data flow, I am...

mgale1

01-06-2007 09:29 AM
Allan Mitchell

Hello Everyone i have an ActiveX Script that returns with a global variable then in the workflow i have an sql task that insert this global variable...

Mariame

01-06-2007 03:10 AM
Allan Mitchell

Hello all, I'm brand new to SSIS. Other than going through the tutorials in SQL Server Help/Books Online, I have not yet created a successful SSIS...

Conan Kelly

01-06-2007 03:02 AM
Allan Mitchell

Here's an idea Add our Row Number Transform to the pipeline and then conditionally split off the rows where the RowNumber column is > 3 --

Allan Mitchell

01-06-2007 02:55 AM
Allan Mitchell

Why on earth you would call a DTS package using a trigger is beyond me....! But lets see.... I have a feeling the DTS package is taking time to...

Query Builder

01-05-2007 01:06 PM
Query Builder

Hello I am importing data from an Excel spreadsheet into a table, via DTS. I am trying to use a named range in the spreadsheet, and have used...

dcrawley

01-05-2007 09:46 AM
dcrawley

I need help on VB Script or better way, what i am trying to do. I have more than 75 TXT files & this all 75 TXT files consists & follows naming...

myrights99@gmail.com

01-04-2007 08:34 PM
myrights99@gmail.com

Racking my brains on this...we had to change our sa password. The sa password was associated with many DTS packages on our production SQL 2000 SP3a...

jsheldon via SQLMonster.com

01-04-2007 07:37 PM
jsheldon via SQLMonster.com

oops, should be "I have attempted to load a variable using "Row Count" with the number of new records found but could NOT get it to work," "GeorgeM"...

GeorgeM

01-04-2007 07:06 PM
Allan Mitchell

I've got a slew of unix shell / oracle type processes that users manually run by logging into the unix server and executing. Its the wild west. On...

jobs

01-04-2007 05:03 PM
jobs

The simplest way would be to just run xp_cmdshell 'dtexec.exe ...' Which would execute your package. You could dynamically create the full...

Rick Razzano

01-04-2007 04:01 PM
Allan Mitchell

OK let's look at this. Read the File as normal. The structure of the lines regardless of line type can be the same. Use a FF Source Adapter Get A...

Allan Mitchell

01-04-2007 03:54 PM
Allan Mitchell

Certainly possible yes. If you do a Google you will see some good examples of VBScript and writing to a DB. Another way of doing it would be to...

Allan Mitchell

01-04-2007 03:46 PM
Allan Mitchell

Hi I am trying to import a .csv file into SQL Server 2005 via Integration Services. Created the Flat File connection all OK and the SQL...

brucemccann@gmail.com

01-04-2007 03:27 PM
Allan Mitchell

I am importing data from a text file to a table in SQL server and would like all error messages in the dts package log exported to a text file. Any...

pfragle@hotmail.com

01-04-2007 08:26 AM
pfragle@hotmail.com

Hello Ken, I think it is possible to feed more than one failure link into a single task but the problem you encoutnered might be related to this...

Allan Mitchell

01-03-2007 08:03 PM
Peter Yang [MSFT]

I have a web service task in SSIS that executes a web service method that returns XML data. I have verified using a simple .NET application that the...

Rick Razzano

01-03-2007 12:23 PM
Rick Razzano

I am an newer. How to retrieve a returned string from web services to variables? I have a web service, which return a string. When I use web...

ABC

01-03-2007 07:00 AM
ABC

How do you process all files in an FTP directory - similar to a for each loop. I need to be able to download each file and move it to an archive...

Charoniv

01-02-2007 10:26 PM
Charoniv

Can anyone tell me how to access DTS properties (such as global variable values) via TSQL? Examples would be nice. Thanks

BLS

01-02-2007 05:17 PM
BLS

Hi all, I have a newbie question. In my SSIS package I have 2 sequence containers, A and B. If A is successfull then B runs. If A is failing, a...

Konsulenten

01-02-2007 04:42 PM
Allan Mitchell

Todd, Does this way around work? http://wiki.sqlis.com/default.aspx/SQLISWiki/EmbeddingDTS2000PackagesInSSIS.html -- Allan Mitchell

Allan Mitchell

01-02-2007 04:17 PM
Allan Mitchell

I have a DTS package that reads data from SQL-Server and exports it to a file using a TextFile connection. When I export numbers using the Copy...

stefanjohansson_2005@yahoo.se

01-02-2007 04:15 PM
Allan Mitchell

You can certainly do this although I do not like to think of DTS as an attended user interaction application. What you would do is pop up the...

Allan Mitchell

01-02-2007 03:55 PM
Allan Mitchell

Do you have any folder structure here C:\Program Files\Microsoft SQL Server\90\DTS It is right that if you installed the whole of the dev edition...

Allan Mitchell

01-02-2007 03:30 PM
Allan Mitchell

How do you set a path from a variable for a for each loop container to enumerate the files. I want to be able to set the path at runtime so that we...

Charoniv

01-02-2007 06:08 AM
Nigel Rivett

Hello all! I would like to create a database DTS package to import a data from MS Access table into the SQL Server 2000 database. I use a import...

Marcin Zmyslowski

01-02-2007 02:13 AM
MB

Hello Mike, I believe you need to select the "Save Password" in the connection and make sure your package settings allow saving of sensitive...

Simon Sabin

12-31-2006 04:40 PM
Simon Sabin

Hi, I have one problem. In SQL 2005 I have SSI package to export data to some excel files. I have for loop container with some job (one of the job...

Radovan

12-29-2006 08:45 AM
Allan Mitchell

Hey there! does anyone know a good site/documentation about the SSIS expression script language (e.g.: used in Derived Columns)? Thx, Chris

Christophe Leroquais

12-28-2006 05:12 PM
Darren Green

giovanni wrote: It's a bit confusing. When you are in SQL Server Management Studio and you ask that an SSIS task "on the server" to be executed you...

Rick Brandt

12-28-2006 10:24 AM
Rick Brandt

I dont know why I am getting warning "33% of consumed workload has syntax errors." I created the trace file using profiler and fed that file into...

SQLBEE

12-28-2006 03:22 AM
SQLBEE

Hello - I want to use the SSIS Foreach File Enumerator in a package that loads files into one table, but also in that table update the...

WalterWalt

12-27-2006 05:30 PM
Allan Mitchell

Excellent! Works Great. I added a line a of code to check for Nulls too. If IsNull(DTSSource("Column")) Then DTSDestination("Column") = null ElseIf...

RLoski

12-26-2006 01:56 PM
SamK

Using Exchange Server 2003/Outlook 2003, we have created a custom Help Desk form in Outlook. We would like the ability to link specific fields from...

Jeff

12-25-2006 05:14 AM
Allan Mitchell

Not sure I am expressing myself correctly, but here it goes. I'm developing an MS Access (2002) software package using Microsoft SQL 2000 on Windows...

brosner@optonline.net

12-24-2006 05:54 AM
brosner@optonline.net

I can't seem to develop VBScript ActiveX scripts. The default now is JScript. The Language drop down shows JScript, SignedJScript...

RLoski

12-23-2006 03:59 PM
RLoski

Here are a few ideas about where to look to convert...

Allan Mitchell

12-22-2006 03:55 PM
Allan Mitchell

Dear Russel, Thanks for the response .. Yes i wish to roll back the truncation statement or delete statement RLoski wrote:

karthik

12-22-2006 06:12 AM
Allan Mitchell

Hi, I've got a big problem with SQL Server 2000 DTS and I hope that you could help me. I'm making a package (PKG A) calling an another one (PKG B)...

Kurt

12-22-2006 04:58 AM
Allan Mitchell