I have a DTS package with Transformations that look like this: Function Main() DTSDestination("PART_PAY_PAYMENT") =...

robboll

06-14-2010 05:20 PM
robboll

Hi, I am trying to run an SSIS package from SQL server agent. The package has one script task that uses an ADO connection. When running the package...

shnel

06-11-2010 08:45 AM
Bernardo Romero

Hi, trying to run an SSIS package (SQL 2008) using the 32bit DTEXEC (due to 32bit Oracle client) on Windows 2008 64bit with 64GB of RAM. The...

Landry

06-10-2010 10:10 PM
Landry

Am running in BIDS using the SQL 2005 SSIS sharepoint list source and destination source to identify the doc lib. Have a test doc lib setup with...

HaroldH

06-10-2010 10:26 AM
HaroldH

Is it possible to use variables that are specific to a sequence container only ? Variables are available in the Control Flow and Data Flow Task areas...

jm27102

06-08-2010 12:14 PM
jm27102

Hi, I am having a strange issue while setting up package configurations. First, I have set up an environment variable with the below value: Data...

Neeraj

06-07-2010 05:18 PM
Neeraj

I'm a newbie to SQL Server 2008 Integration Services (I have done some DTS packages in SS 2000) and I was wondering why the Fuzzy Lookup component...

Crazy Cat

06-07-2010 11:31 AM
Crazy Cat

Hi there, I'm using SQL Server 2008 And I have a table called myProgress with column name summary data type xml looks like that <?xml...

odeddror

06-05-2010 03:58 PM
odeddror

Our nightly datawarehouse update processing is periodically failling on an irregular basis. No useful errors in Windows logs, SQL logs, or SQL...

dworxClint

05-28-2010 11:31 AM
Carla Sabotta

Any idea how to diagnose a timing out error? Sometimes it happens when the package just starts running, other times after it has processed thousands...

Dorian

05-27-2010 05:44 PM
Dorian

What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft...

nntp@microsoft.com

05-21-2010 05:54 AM
nntp@microsoft.com

We are having a strange problem with a DTS package running on SQL 2005 after our upgrade from SQL 2000 this week. The first step of the package just...

Jason Fisher

05-20-2010 11:55 AM
Jason Fisher

I am very new to SSIS 2005 I have a sql command Select count(*) from table_a. The result is stored in a global variable. In a script task, if the...

The Other Mike

05-18-2010 08:45 AM
Todd C

I am using SSIS 2005 to import a text file, do some lookups and then send the output to subfolders on the destination hard drive based on certain...

imani_technology_spam@yahoo.com

05-13-2010 11:46 AM
Todd C

Hi all, been working on this problem for a while now but having little success finding a satisfactory solution. I have a DTS package which contains...

VegaLA

05-10-2010 05:41 PM
VegaLA

Ok Gurus, Here is an interesting situation, I have a coworker that has a flat file with no column headers that needs to be imported or appended into...

Bill Orova

05-05-2010 04:49 PM
Todd C

What could go wrong here? I created a simple DTS Package to copy one DB from server A to server B using the Copy Database Wizard. The Package is...

David

05-03-2010 04:56 AM
David

I have some scheduled dts packages. They error out with this message every time. I can run the package manually with no problem. Step 'Copy Data...

Leslie

04-29-2010 10:51 AM
Gaurav

Hi -- MS SQL2008. I want to export a table1 to MS Access so I using Export data. While it is exporting to the last step I got an error " OLE DB Size...

MN

04-29-2010 08:50 AM
Todd C

I'm getting "The Data Pump Task requires Transformations to be specified" error. The package has everything specified correctly. The package was...

Dorian

04-26-2010 06:48 PM
Dorian

Hi I have a really simple DTS package that loads a .csv into a table using a Transform Data Task. Very occasionally, I get a primary key violation...

NH

04-23-2010 08:28 AM
Paul Shapiro

I’m having difficulty figuring out why the sample HelloWorld custom task is not showing up inside of BIDS (SSIS Data Flow Items tab). I’ll be...

Dave

04-16-2010 07:24 PM
Dave

We have DTS package with isolation level of 'read commited'. In this is a vbscript task that opens a recordset and loops through it. Question: is it...

Dorian

04-15-2010 05:12 PM
Dorian

Hello all, I have a execute sql task in a container with other tasks. This is all the task has in it DECLARE @RC int EXECUTE @RC = ...

William E. Booth

04-09-2010 06:06 PM
William E. Booth

I am executing a sql file through dts. Is is possible to get complete sql execution log (i.e. so many rows updated etc.) and not just step failure...

pradeep

04-08-2010 11:05 AM
Zodiac

SSIS Community: I have some .txt files I need to work with in SSIS. When I create a Flat File connection, the connection manager does not seem to...

JJ of Eugene OR

04-06-2010 12:13 AM
SQL Lion

Hi I want to edit a query that I pasted into the DTS package when running the import wizard. Is there a way to do this without having to rerun the...

Mitchell_Collen via SQLMonster.com

03-31-2010 02:12 PM
Mitchell_Collen via SQLMonster.com

In order to copy all files in certain folder to another folder (with the same file name) I have placed a File System Task inside the foreeach...

rkbnair

03-30-2010 03:15 PM
Joshi

Hi Guys, I'm currently using SSIS to copy data from a source table, change some of the datatypes and pump it into a destination table. The problem...

lloyddsilva@gmail.com

03-30-2010 09:04 AM
sneha

Hi - I'm not familar with DTS deatils. I was wondering if Microsoft has a tool in either SQL 2k5 or SQL 2k5 SSIS which "converts" SQL 2k DTS...

Steve M

03-30-2010 08:36 AM
Todd C

Hopefully someone can help me with this. I have an SSIS package that runs great in all my environments. However, this package recently stopped...

Chris

03-29-2010 05:05 PM
Ricky Hall

I'm (attempting to) converting a legacy Perl program to SSIS. The apps purpose is to sign in to a web service, submit a request and receive an...

Peter

03-29-2010 12:29 PM
Peter

Is there a way for a DTS script (vbscript) to tell which server it is running on? Is there any reason I cannot set a variable using this technique...

Dorian

03-24-2010 12:09 PM
Dorian

How are DTS packages normally promoted from development to test and test to production? I need to update a DTS package, both the number of steps in...

Dorian

03-24-2010 10:23 AM
Dorian

Hi, I have a problem which is causing us grief and we don't know where to look next. We have an SSIS package. The said package runs at an acceptable...

Kevin

03-23-2010 07:44 AM
Todd C

Hi, I am having a problem doing a quick and dirty export from a table to a csv file. It is not a job just a quick run, never experienced this...

Brian

03-23-2010 07:40 AM
Todd C

I am using SQL Server 2005 and trying to import a CSV file on the web. I am not a programmer so I was just trying to use the import and export...

RedGlow06 via SQLMonster.com

03-19-2010 05:05 PM
greenmtnsun

So if we created a an OLE DB Source with this SQL select field_1, field_2, field_3 from table_1 For XML AUTO It would create xml results from the...

Hotwheels

03-18-2010 12:31 PM
Hotwheels

Please advice on How to Execute a DTSX package from VB.Net 2003.

chiks81

03-18-2010 06:45 AM
Todd C

It appears I had successfully migrated sql server 2000 dts packages to sql server 2005. However, I can't find them on sql server 2005. How do...

RG

03-18-2010 06:39 AM
Todd C

I would like to accomplish the following: 1. Send Mail to an email address and individual's name retrieved from a list retrieved by a select...

VSLA

03-17-2010 03:26 PM
VSLA

Dears, I'm trying to import excel sheet using SSIS, however if there is any cell that has formula (C1 = A1 + A2), it appears as null.

Tareq Ali, MVP

03-17-2010 07:07 AM
Todd C

I had to change the administrator password on a sql 2000 server and now the packages under Data Transformation Services will not open up. I get...

Helpdesk

03-16-2010 02:28 PM
Helpdesk

Can someone tell me if the "Microsoft Connectors for Oracle and Teradata by Attunity" works on SQL Server 2008 Standard? The following link states...

greenmtnsun

03-11-2010 07:09 PM
greenmtnsun

If I have an "Execute SQL Task" with sql that looks like this: SELECT FLAG FROM "MyDB"."RUNorHOLD" WHERE FY = '2010' AND PER = '4' How can I turn...

robboll

03-11-2010 09:38 AM
ROBBOLL

I have an execute sql task with the following query against adventureworks2008 SELECT description, modifieddate FROM ...

Mark

03-11-2010 08:59 AM
Todd C

hi, i would like to know how i can create a dts package which contains 3 queries, each creating a separate csv file. can someone list the steps...

geebee

03-08-2010 10:29 PM
geebee

We are new to SQL Server 2005. When we import SSIS Package, there are 2 options - File System or MSDB file. Which one should we choose ? Thanks

Patrick

02-23-2010 03:46 PM
Patrick

Hi, During a project I gained a lot of knowledge of using the Theobald Xtract IS DeltaQ component, which I like to share with you all. I have...

Johan Machielse

02-22-2010 09:35 PM
Todd C

We have written a simple app that executes a simple DTS package constantly to monitor memory. We were expecting to see memory usage maintained at the...

Webmonkey26

02-12-2010 04:17 AM
Webmonkey26