I have sql server 2005 standard edition version 9.00.3054.00 (service pack 2 installed). Recently, I have run sql server hotfixes deliveres over...

=?Utf-8?B?QW1pciBTdGV0YQ==?=

08-04-2008 11:47 AM
Datta

Hi All, Certification in Mind??? Visit www.itjobguru.com for Latest Material. Regards, Naveen

Naveen

08-03-2008 02:46 PM
Naveen

I am creating a SSIS package that will basically act as an aduit for my profiles database. I have several querys that will run and will dump the...

Chris

08-01-2008 08:44 AM
Todd C

Hi, I have a table from which I would like to extract 3 text columns in a copy column data transformation task. I am getting an error: Unspecified...

Kevin Doyle

07-31-2008 01:36 PM
Kevin Doyle

I would like all records inserted into a database table to be copied into a text file. (A 3rd party application will move this file and import...

Mark

07-31-2008 12:10 PM
matteus

Can anyone please advise what i am doing wrong, I am trying to pass variables to a DTS package using the following stored procedure, but...

John Peach

07-31-2008 09:47 AM
John Peach

Can i know where can i find any good DSO scripting examples other than MSDN site

santosh

07-31-2008 04:51 AM
santosh

I am not a developer. I am SQL Admin. I want to write an SSIS package. The package should go and query msdb databases of all corporate SQL servers...

Moh

07-30-2008 04:27 PM
Moh

Hi... I work with xml files, I use a foreach loop for process them. I want to save the xml data into a table... I can use this query: DECLARE @xml...

Anja

07-30-2008 11:32 AM
Gerald Aichholzer

I want to use SendMail task to send an email - only if data exists in table. easy enough, however to check if data exists I have to go to data flow,...

Chris

07-30-2008 04:30 AM
matteus

I have a boolean type variable - pIsExists I created an Execute SQL task to set this variable - ResultSet: Single Row SQLStatement: select 0 as...

Chris

07-30-2008 03:51 AM
matteus

I believe this to be a File System security issue but I can not get beyond it. In my test I am using: XML, to call a stored proc which executes ...

briang

07-29-2008 02:11 PM
briang

Hi I want to move some files to an archive folder once they processed - how can I do this using dts package eg. c:\file1yymmdd.xml ->...

jojo123

07-29-2008 08:41 AM
matteus

Folks I am trying to setup an MS SQL server 2005 DTS package to import data from an As400 DB2 server. I have the choice between 3 different...

AlexT

07-28-2008 02:19 PM
sastha

When I run this certain SSIS package ON the server its deployed to, then it runs fine, no worries. When I try to run the package from my...

Carl Henthorn

07-28-2008 03:05 AM
matteus

Hi all, I'm fairly new to SQL Server 2005 Integration Services and I'm looking for an online SIS Glossary of Terms with a list of keywords used in...

AEdw

07-26-2008 04:53 AM
AEdw

Hi, i have a foreach loop that loops through ADO recordset. In that loop i have a execute package task (lets call it SubmitData), which executes...

meska

07-25-2008 08:37 AM
Todd C

Hi, I created a DTS package using import/export wizard in SQL 2005 SP2 eviroment, then I saved it on server. However, when I looked for it,...

sg

07-23-2008 02:58 PM
Todd C

Good Afternoon, i tried this thread on a .NET Forum, and it seems that this forum would a more likely candidate for help. What i am trying to do is...

Krzysztof via SQLMonster.com

07-23-2008 10:36 AM
Krzysztof via SQLMonster.com

Hi all. I have a dts package that ran perfectly (has been scheduled). The sa password has been changed and now when I run the package I get Login...

Driesen

07-23-2008 05:07 AM
Driesen via SQLMonster.com

I start out with sql 2000 package saved on the server that can be opened on a client pc and on the server using the enterprise manager. If I save...

Benjamin

07-22-2008 02:49 PM
Benjamin

I understand that DTSRUN is not supported in pure 64 bit. Is it supported under X64 (ie just runs as a 32 bit app) ? thanks Peter

Peter Feakins

07-22-2008 10:58 AM
matteus

I want to create a SSIS package to move data from a Foxpro 5.0 .dbf file to a SQL Server 2005 table. I tried to create a Flat File connection using...

.NET Runtime Optimization Service (clr_o

07-22-2008 10:50 AM
.NET Runtime Optimization Service (clr_o

I'm trying to import a small spreadsheet from Excel into a pre-created SQL Server table. One column is defined as char(2), and the data values are...

D.Stone@ed.ac.uk

07-22-2008 09:56 AM
D.Stone@ed.ac.uk

Hi, I have a simple SSIS Package where I'm trying to move data from one SQL Server instance to another. When debugging the package in the SQL...

urig

07-21-2008 08:08 PM
Ken Ferrell

Hi Everyone, I'm sure i have a fairly simple question but i'm pretty new to SQL2K5 SSIS. I'm looking to see the best approach to normalizing some...

Michael Morse

07-21-2008 09:08 AM
matteus

I am trying to execute an SSIS Package and the SSIS package threw the following errors: 1.) Executed as user: MyDomain\Administrator. ...00.3042.00...

Prahalad Deshpande

07-21-2008 08:45 AM
jhofmeyr@googlemail.com

I have an SSIS package which has for each loop, inside the loop 3 parallel tasks should execute which are linked to another task. Whenever I run the...

SalamElias

07-20-2008 11:13 PM
Charles Wang [MSFT]

Hi, I'm wondering if this can be done. DTS will export query results into a flat file, is it possible to continue to email this flat file? Thanks a...

sg

07-18-2008 11:38 AM
sg

Hello, I know how to use DTSRun.exe. I also can redistribute only the files for DTS (as indicated in redist.txt) for a normal client, which does...

Joachim Hofmann

07-17-2008 06:29 AM
matteus

Without having to recreate this processing in SSIS, I have an existing Access program which I can run by commandline. The batch file runs an...

Greg

07-17-2008 06:12 AM
matteus

Hi All, I have created a query to run in a .dtsx package. I would like to parameterize it so that a user can input a value via the Execute Utility...

Gloria

07-16-2008 02:17 PM
Todd C

We are running SQL server 2000 with DTS. We have a stored procedure which worked fine for quite a while. We had to change it recently and since then...

Andrew

07-16-2008 12:56 PM
matteus

In my SQL Server 2000 DTS package i need to send e-mails to the list of recipient. I am using xp_smtp_sendmail stored procedure. When i send email...

Bhuvaneswari Ramamurthi

07-16-2008 05:10 AM
matteus

Hey folks... I have 7 DTS packages that connect to my remote SQL Server and transfers data to my local server (back it up). I've made a job that...

Christiano

07-16-2008 04:55 AM
matteus

Hello - Is it possible to view all of the SSIS packages in SQL 2005 like we use to be able to view the DTS packages in SQL 2000? I cannot find...

dw

07-16-2008 04:37 AM
matteus

I am using SQL Server 2005 on a Windows XP (sp2) PC. Whenever I run a DTS Package that has an ActiveX Script Task in it, which contains the...

bjb2412

07-15-2008 02:00 PM
bjb2412

We have a production SQL 2005 cluster running SSIS, and we need to restart SSIS. Is it safe to restart the SSIS service without affecting...

Mike Baker

07-15-2008 01:16 PM
Mike Baker

*Jälleen kerran on syytä tuoda esille sitä faktaa, erttä ydinvoima on menneisyyden tekniikkaa ja tällaiset alla olevat mm. päästöttömän...

Anssi Sandberg

07-14-2008 11:11 PM
Anssi Sandberg

I need to encrypt and decrypt certain columns in certain tables inside a stored proc. Can this be done and if so how? Thanks for any advice. This...

mscertified

07-14-2008 08:08 PM
mardukes

I am trying to move data from a flat text file to an Oracle database, using a DTS (it's a long story). I am using a DTS because some of our servers...

thursday's geek

07-14-2008 05:22 PM
thursday's geek

Hi, I am trying to call a sub DTS package from the main DTS package. When i trying to call, i am getting the following error.

RajaGanapathy

07-11-2008 10:57 AM
RajaGanapathy

Get the latest updates in SQL server 2008 tools and techniques and more about database management, software testing, flowchart prepartation and many...

surana

07-10-2008 09:21 PM
surana

Oh great magi of Microsoft and Oracle, please help me! I'm trying to get SSIS to connect to Oracle on 64-bit, but I'm having trouble. It's running...

Joseph D. Wagner

07-10-2008 03:05 PM
Russell Fields

Hi experts, I have no idea why development of SSIS is easy but is hard when comes to deployment with the wizard and copy the installation...

Daniel

07-10-2008 11:43 AM
Daniel

We need to set up a monthly 'job' that reads and writes from our SQL Server 2005 database and creates FTP files. The logic is quite complex, its goes...

mscertified

07-10-2008 08:45 AM
Todd C

Hi, I have an SSIS package that use a #temp table to store the list of ID to compute in different DataFlows and SQL Tasks. This package has 2...

Ryo

07-09-2008 10:01 AM
Ryo

I have a SSIS package that works fine when run inside Visual Studio. It runs fine when run using the DTEXEC command in a cmd window. It runs fine...

Irvine, Dennis

07-07-2008 05:51 PM
Irvine, Dennis

I've just begun working with SQL Server (2000) recently and have some familiarity with setting up DTS packages. I also have a lot of experience with...

Klein-4

07-07-2008 05:49 PM
Klein-4

I am working on an Access application which must execute a DTS package. Since the workstation that will run this application does not have any...

Sheldon Penner

07-07-2008 05:44 PM
Sheldon Penner