Hi- I have a default SS 2000 database with multiple scheduled DTS packages that run daily. I need to install a SS 2005 instance on the same server...

wiseteufel via SQLMonster.com

02-25-2008 12:04 PM
wiseteufel via SQLMonster.com

Hi, I am somewhat new to using DTS packages. Generally, I want to know if it is possible to not only import data into an existing Excel...

psrd66

02-25-2008 11:55 AM
psrd66

Since getting an MSDN subscription a few months ago, I have made about 6 posts. I received one response from a Microsoft person telling me that...

walter1234

02-24-2008 05:29 PM
Dave Patrick

RE: XML Data source .. Expression? Variable? Connection? Error: unable to read the XML data. I want my XML Data source to be an expression as i will...

wildman@noclient.net

02-23-2008 12:25 PM
wildman@noclient.net

It took a while but I figure out I would need a file connection for each type of file I would be renaming in my File System Task Rename. Or so it...

wildman@noclient.net

02-23-2008 10:07 AM
wildman@noclient.net

ummm. sorry, I've read and seen the tutorials but somehow missing how to do this. I have a foreach container. Inside a dataflow task, with an...

jc

02-23-2008 10:05 AM
wildman@noclient.net

I'm trying to rename a file based on success and failure of a data flow task. I'm in a foreach loop container. Trying to configure the file system...

wildman@noclient.net

02-23-2008 08:47 AM
wildman@noclient.net

I have a c# program which executes an SSIS package. I installed it on a target machine using Click-once. I am getting a runtime error which...

walter1234

02-23-2008 08:12 AM
walter1234

Did I miss a step in the VS.NET 2005 install. Or maybe it was SQL 2005 install. I can't seem to find samples like this...

jc

02-22-2008 08:23 PM
jc

I inherited a SQL Server that has lots of DTS packages set up. I found some of them being executed from Scheduled jobs but many of them were used to...

sharman

02-22-2008 09:36 AM
sharman

Hi Everyone, I am new bie to SSIS. I need to export the data from sql server 2005 to Excel 2007. I have installed Access Database Engine on my...

muralimohan.cse@gmail.com

02-22-2008 12:36 AM
muralimohan.cse@gmail.com

Hello all, I want to know if it's possible to make a select statement that brings only the records with a number of bytes of less than 8060 so,...

segis bata

02-21-2008 09:40 PM
segis bata

Hi All, i'm new to world of SSIS(just 2 days). While creating few samples i came across a issue where i need to do look up. Let me tell u...

steven.p24@googlemail.com

02-21-2008 11:21 AM
jhofmeyr@googlemail.com

I have moved some DTS packages from SQL Server 2000 to SQL Server 2005 and the DTSLookups not only do not work but the GUI to maintain DTSLookups...

Scagnetti

02-21-2008 11:02 AM
Scagnetti

When run an export from a SQL 2006 (64bit) to either a C: on the server or another SQL 2005 (32 bit) the following error message occurred. Error...

Robin9876

02-21-2008 06:11 AM
Robin9876

Hello, I have a pretty basic DTS package. All it does is take a text file and import it into the sql server database. I created a global variable...

Patrick Hill

02-20-2008 10:43 AM
Patrick Hill

Hello, I created a DTS package (pkgParent) that uses an Execute Package task to execute a package on a remote server (pkgChild) as its final...

Eric Bragas

02-19-2008 02:30 PM
Eric Bragas

Hello: I know how to DTS data from one table in a database to an identical table in another database in SQL 2000. It's pretty easy. But, what if...

childofthe1980s

02-18-2008 02:52 PM
Russell Fields

Hi Everyone - I have an SSIS package that is dynamically executing other SSIS packages through an Execute Package task. That is all working...

Ken

02-18-2008 01:44 AM
Charles Wang[MSFT]

Hi, I'm using ADO.NET Oracle Client as the provider to connect to an Oracle 9i database in SSIS 2005. The problem is after the package finishes,...

Daniel

02-18-2008 12:04 AM
Peter Yang[MSFT]

Hi, I am using DTS package on SQL 2000 Server. Is there a way I can import data from source and base on the data on the source, insert them into...

Danny Ni

02-17-2008 05:51 PM
Danny Ni

I need to stop a SSIS package from logging to the windows eventlog. I have disabled logging and it still writes to the event log if the package...

Ewok71

02-17-2008 03:19 PM
Ewok71

Hello, I am trying to programatically create an SQL Server destination in SSIS. I am creating the connection string, then initiating a connection,...

hanan.taiber@gmail.com

02-17-2008 08:10 AM
hanan.taiber@gmail.com

In a project I have created 6 dtsx packages, all doing about the same thing: sql task defines highest date in database and store in variable script...

jos

02-16-2008 02:31 PM
jos

Hi I have a excel file that I import into sqlserver. then I execute a sql task to alter some data. after this task I want to export the data to...

Luke

02-16-2008 10:07 AM
Jack Vamvas

I was wondering if someone could shed some light on my issue. SSIS, can't use linked servers. I have to pull a view over from Server 2 and then run a...

mac

02-15-2008 09:34 AM
mac

I have a dts package that has 4 branches that run at the same time. I was wondering what are my limits on increasing these branches? This server...

Chris

02-13-2008 09:13 PM
Chris

I have an 'Execute SQL task' which saves its rowset into an output global variable. Is there a way to transfer this data to Excel without using...

John Dalberg

02-12-2008 03:56 PM
John Dalberg

Using SQL2K. I'm extracting columns from a CSV file. Once column, in the CSV file, has a format of general and is only populated by numbers (0 -...

qdaddyo

02-12-2008 11:11 AM
qdaddyo

Hi I have a DTS package that imports some data into a database and when the package it finishes with a mailtask that sends a mail on completion. Some...

A.

02-12-2008 09:16 AM
Blake Robertson

Hello guys, I need to build a dts package to do to the following: * run a vbscript in a remote sql server * copy some tables from the local to a...

zerbie45@gmail.com

02-12-2008 08:33 AM
nite_eagle@hotmail.com

Does the SSIS OLE DB Command transform not support the simultaneous use of XQuery (to extract data from an XML data type) and a parameter? When I...

Blake Robertson

02-11-2008 09:10 AM
Blake Robertson

it is possible. Some of my production systems work this way, meaning the windows authentication is used in the ssis package and this package is...

Allan Mitchell

02-11-2008 06:42 AM
Liliya Huff

I use iSeries ODBC drivers for connecting on AS400 UDB. My problem is that SSIS connection does not remember password. Connection string is...

TomislaW

02-10-2008 02:19 AM
TomislaW

Hi, I am trying to create packages on SQL Server 2000 to import data from Excel file or text file into SQL server tables. What I really want is to...

Danny Ni

02-09-2008 05:00 PM
Danny Ni

Hi I have one ActiveX Script task and VB script written in it is : Function Main() dim SQLConn dim Sql dim RS set SQLConn =...

appu

02-08-2008 11:28 AM
appu

Hello, during scheduled running of some packages I get this Warnings in the log file. The buffer manager detected that the system was low on...

Radu Colceriu

02-08-2008 04:40 AM
Radu Colceriu

Hi All, Basically what I am after is a few pointers on how to import some .txt files from a folder into a SQL table. We are using SQL2000 What the...

David C

02-08-2008 04:05 AM
jhofmeyr@googlemail.com

Help!! I have a DTS, where in the Transform Data Task it runs a query, then throws it into a CSV, with changing some fields to quotable fields,...

Rich

02-08-2008 03:58 AM
jhofmeyr@googlemail.com

Sometimes when I use a Transform Data task, enter a proc as source, the transformations tab does not show any columns in the source list and the task...

John Dalberg

02-08-2008 03:54 AM
jhofmeyr@googlemail.com

I would like to export data from a SQL Server 2000 database to an excel spreadsheet. I have been able to run the export successfully. The...

doug

02-07-2008 06:32 PM
John Dalberg

Hello, I just did an upgrade of our sql2k to sql2k5 and encountered the following error message when trying to open and edit one of our DTS...

zz12

02-07-2008 11:46 AM
zz12

Hello All, I am trying to find a way or best way to automatically print reporting services reports using a Script Task in an SSIS package. Does any...

bjk1903

02-07-2008 10:07 AM
attilat13@gmail.com

I am declaring maxdate as date. This should be filled with the output of a select command to sqlserver2005 "select max(date_proccessed) from...

jos

02-07-2008 05:58 AM
jhofmeyr@googlemail.com

I've got two very similar tables on seperate servers and databases. Both sqlserver. I am being told I cannot link the databases. I need to keep one...

wildman@noclient.net

02-07-2008 04:28 AM
jhofmeyr@googlemail.com

I created a Execute SQL Task that queries two columns from an Oracle table and stores them in a recordset global variable (to be used below in...

Alex Wolff

02-07-2008 04:05 AM
Phil

Hi I've created and saved an SSIS package as a dtsx file. It's a simple file for exporting data from one MSDE 2000 database to another in the same...

Andrew Jocelyn

02-06-2008 06:32 PM
Bob

Hi there, I was wondering if you could point me in the right direction on how I could create new csv/ txt files whenever a SSIS package is run? As...

ann.marinas@gmail.com

02-06-2008 04:33 PM
ann.marinas@gmail.com

Is it possible to run an Oracle stored procedure within a DTS task or ActiveX script? Thanks.

Alex Wolff

02-06-2008 03:45 PM
Alex Wolff

Hello, What's the best way to copy jobs from one Server to another? ...Both servers are using 2005 thanks in advance, bob.

Bob

02-06-2008 10:47 AM
Bob