Hi, How do I reference and modify package scope variables in a script component (within a data flow task)? I tried copying the syntax I used in a...

artzoop@hotmail.com

10-04-2006 12:21 PM
Charles Kangai

Issue: Msg 4822, Level 16, State 1, Line 1 Cannot bulk load. Invalid number of columns in the format file "C:\INFO_CUT.XML". I have checked and...

ELDER_GEEK

10-04-2006 12:13 PM
ELDER_GEEK

Greetings. I have created a dts package that uses a .Net dll through COM Interop in an ActiveX script task to generate pdf files from Reporting...

Dale M.

10-04-2006 10:26 AM
Dale M.

I wan't to run a dts with a stored procedure using xp_cmdshell and dtsrun. The thing is if i run dtsrun.exe in a command prompt it...

arnoled

10-04-2006 10:22 AM
arnoled

I need to extract data from an Oracle 10g database to SQL server 2005 data mart using a pl/sql procedure to do the extract from the source system. ...

vnapoli

10-04-2006 09:25 AM
vnapoli

I have been trying to create an active x script to allow a user to dynamically create the name of the file by using a dynamically supplied msgcode,...

SimplySuzy

10-04-2006 05:40 AM
Charles Kangai

Greetings, I am trying to import an excel spreadsheet into my database. The spreadsheet contains the list of dealers for the site and this...

irishdudeinusa

10-03-2006 10:57 PM
irishdudeinusa

Hello, I would like to ask how to add class Microsoft.Sqlserver.dts.pipeline.wrapper in script task.. Thank you, Reda

reda246@gmail.com

10-03-2006 02:19 PM
reda246@gmail.com

Hi all, I've spent about 3 days trying and hitting dead ends on how to execute an SSIS package programmatically. Anyway, after failing with SQL...

JasonBarton

10-03-2006 01:55 PM
Charles Kangai

Does anyone know type of connection to use to connect to a Fox database table in ETL. Nothing I try seems to allow me to access the data so I can...

Simon

10-03-2006 03:16 AM
Simon

Hi. After applying SP1 on my SQL Server 2005 developer edition on my laptop, there is no longer a File enumeratorin the Foreach Loop container. I...

Lorents Nord-Varhaug

10-03-2006 02:28 AM
Lorents Nord-Varhaug

Hi, Is it possible to get transaction support between two ms-sql servers (ms-sql 8.0) on windows 2003 servers, on different nettworks with firewall...

Willy S

10-02-2006 09:17 AM
Willy S

We have SQL Server 2005 and have installed the "add-in" that allows us to edit DTS2000 packages. However there seem to be two areas that were...

Rick Brandt

10-02-2006 07:36 AM
Rick Brandt

I have an SSIS package that recently hung in the middle of execution. It was in the middle of a ReadCommitted transaction that is accessing one...

Hasan Quadri

10-02-2006 02:06 AM
Peter Yang [MSFT]

I have a MSDN SQL Server 2005 Developer edition disk called as SQL Server 2005 CTP what is this CD ? is it the 2005 beta CD please confirm. Is it OK...

karenmiddleol@yahoo.com

10-02-2006 01:47 AM
Darren Green

Hello to all, I am trying to learn the DTS one step at a time. I want to execute a DTS package using .Net. I got the idea from one of the posts here...

Senthilkumar

09-30-2006 01:36 PM
Senthilkumar

Hi, I have been reading all day trying to figure out this one and I can't find out why I am having this issue.... I have created a DTS package that...

andree_noel@yahoo.ca

09-30-2006 10:20 AM
andree_noel@yahoo.ca

I am trying to issue an INSERT statement from within DTS to Teradata. I want to use "Parameters" as value in the statement. While doing this in...

Umar

09-29-2006 09:15 PM
dh

I need to update a table in the oracle with data that came from the SQL Server but I cant delete all the lines in the oracle I need to check if the...

biano.brito@gmail.com

09-29-2006 04:19 PM
n068615

Hi! I would really appreciate any help on this. I am getting error 0. syntax error in the following activex: Function Main() 'Const...

TG

09-29-2006 02:52 PM
TG

I has a problem with the current database, and change the system to use a old packup of the database, now I recovered the real database, the...

SCSI

09-29-2006 02:40 PM
SCSI

Hi, Is it possible to get transaction support between two ms-sql servers (ms-sql 8.0) on windows 2003 servers, on different nettworks with firewall...

Willy S

09-29-2006 05:15 AM
Willy S

I'm building packages programmatically. I notice that if I open them in BIDS afterward building them and make a change, my package grows in...

js

09-28-2006 08:05 PM
js

Hi, I am trying to build an automated process that would allow someone to upload a CSV file via FTP to a specific folder and then the DTS package...

PizzaGood

09-28-2006 07:17 PM
PizzaGood

Hi, I am getting an error "SQL Server does not exist or access denied." when I try and execute a DTS package from VB.NET (forms) using the method...

damian_meleo@hotmail.com

09-28-2006 07:13 PM
damian_meleo@hotmail.com

Hi Everybody, I am having problems in DTS packages that runs nightly. It is always the same Error at the same 'Execute SQL Task'. The ohter...

gollo007

09-28-2006 04:38 PM
Charles Kangai

We have been getting a strange error with this particuar package that we've been running a scheduled job, from Integration Services and havn't been...

James Wuerflein

09-28-2006 04:36 PM
Charles Kangai

Hi, I need help accomplishing a task and I'm not sure how to go about it but I do know that I want to do it using DTS. I have a text file, A, with a...

Rick Bond

09-28-2006 03:23 PM
Arnie Rowland

Greetings. I have a folder containing a number of .sql files that I would like to execute using Exec SQL task I'm looking for a way to...

Marty

09-28-2006 03:03 PM
Marty

Current prod environment: SQL Server 2000 Newly built prod cluster: 64 bit SQL Server 2005 Is there a way to move and maintain the DTS packages from...

Scagnetti

09-28-2006 02:48 PM
Scagnetti

I don't have accesss to DTSRUN. Can someone tell me if its /L (log_file_name) argument will accept a UNC path? Thanks.

Rick Charnes

09-28-2006 01:08 PM
Arnie Rowland

Hi - I've been having a problem with all of the packages I create. I create them in BIDS on my local machine (which is running SSIS, as I discovered...

bigbrorpi@gmail.com

09-28-2006 11:25 AM
Charles Kangai

Hiya. Im trying to import data tables from MS Access. they contain about 20,000 rows of data. When I attempt to use the DT wizard for the import I...

stephenson22

09-28-2006 10:46 AM
stephenson22

I try to export table with the follow structure TABLE ( int NOT NULL, nvarchar(50) NOT NULL, nvarchar(max), nvarchar(14), ...

Bourg fat

09-28-2006 10:32 AM
Bourg fat

I've got a table sitting on a Sybase ASE server. I'm trying to import about 10% of it into SQL server 2000. When I click on the Destination tab and...

Jason

09-28-2006 06:14 AM
Jason

Hi - I have a 32 bit SQL Server 2000 installation that is current on service packs that is installed on a 64 bit version of Windows 2003 (this...

Steve Mull

09-28-2006 05:24 AM
Steve Mull

I need to import into SQL dbf files. In SQL2KDTS there was an option for this, but in SSIS I do not see an option for dbf files. I tried a few that...

JC HARRIS

09-28-2006 04:51 AM
Charles Kangai

I am looking for some tutorial on SSIS, beside the one from MS online tutorial. Can you help? thanks ken

SQLKen

09-27-2006 06:33 PM
Sue Hoegemeier

I am trying to debug a script task in an event, is this possible? I get a window that opens and contains the script task from the control flow but...

Brian Bagley

09-27-2006 03:26 PM
Charles Kangai

This is a newbie question. I'm starting a new DTS package. I click and drag the Microsoft ODBC drive for Oracle to the IDE. I enter the inforamtion...

mcauliffe

09-27-2006 03:08 PM
Sue Hoegemeier

Hi When I am trying to insert value in remote server (Linked Server) or trying to run query with BEGIN TRAN & COMMIT from query analyzer I am...

Raj

09-27-2006 12:02 PM
Raj

I am new to 2005 and am in the process of moving a developers pkg to the server and scheduling it. I got it moved and scheduled the pkg but it did...

Ferg

09-27-2006 11:44 AM
Charles Kangai

Hi all, How can I have my c# program execute a DTS package on a client PC that doesn’t have SQL client tools installed? I have a c# program that...

Langston

09-27-2006 11:41 AM
Langston

Hi, I need to know how can i transform a value to a letter: It goes from a DB to another... Ex: if 0 to 30 = A, if 31 to 60 =B anyone can help me...

Enrico

09-27-2006 11:41 AM
Charles Kangai

I've had good success using the XML Dataflow to capture RSS feeds. What I need to be able to do is put this XML Dataflow into a foreach container and...

ERHunter

09-27-2006 11:32 AM
ERHunter

I have 40 field databases and 1 consolidated database which is a subset (all tables but not all coumns) of all of the field databases. There are over...

Kirk

09-27-2006 10:17 AM
Kirk

We have an interesting scenario here at work which to be honest doesnt seem very difficult but we have never had the opportunity to try this out. One...

Tony

09-27-2006 08:52 AM
Tony

I have some DTS packages that load a flat file to the SQL 2000 database and then to a AS 2000 cube. I want to migrate this to SSIS on SQL 2005 and AS...

KarenM

09-27-2006 08:42 AM
Charles Kangai

Hi, I have an requirement wherein I get the data in the form of an txt file and I need to push this data onto different tables based on an column....

Sudhakara.T.P.

09-27-2006 08:33 AM
Charles Kangai

I am running several ActiveX script tasks that are basically inserting legacy data into the new DB structure. Using stored procedures with cursors...

Gaye Turnbull

09-27-2006 06:15 AM
Gaye