Hello... I am currently going through a SQL Server consolidation project and have numerous DTS packages across numerous servers that need to...

SQLSQUIRREL

12-23-2008 06:02 PM
SQLSQUIRREL

Configuration: SQL Server 2005 Std x64, version 9.00.3233 running on Win2003. When trying to edit a Data Flow task of a new or existing (added)...

Yura

12-23-2008 11:30 AM
Yura

I've 7 regional production servers that I want to copy to another server every night. Let's call the source production servers 1 through 7, and...

greg

12-23-2008 01:29 AM
Mark Han[MSFT]

Configuration: SQL Server 2005 Std x64, version 9.00.3233 running on Win2003. When trying to edit a Data Flow task of a new or existing (added)...

Yura

12-22-2008 02:46 PM
Yura

I have a job on SQL server that includes vbscript, everytime I try to run it though, I get this error message: "COUNT field incorrect or syntax...

smiths37

12-21-2008 01:32 PM
Dave Patrick

Hi all, I wasn't sure if this is better as a dotnet question, or a dts question.. I have a user signup page that uses the createuserwizard. I need...

Lance Wynn

12-18-2008 10:57 PM
Lance Wynn

I have a stored procedure that drops a table if it exists, re-creates it, and then inserts rows based upon a select query. Pretty standard stuff. ...

Stevent

12-18-2008 08:51 AM
Russell Fields

We have an Excel workbook where certain cells are formatted not to show the decimal places (formatted as number with zero decimal places). As a...

Darren

12-13-2008 01:56 PM
Darren

I can't seem to use a parameter marker (i.e. the ? character) in my Execute SQL Tasks Properties and then be able to select to bring up the...

BuzzCatZar

12-12-2008 06:10 PM
BuzzCatZar

I am attempting to import a CSV file using the Bulk Insert sql command... USE datasheets BULK INSERT tblgrades FROM...

Ripper

12-12-2008 05:44 PM
Peter Gibbons

Hi I am sorry if you have heard this one before. We have had full SQL Server 2000 for years but are migrating to a new webserver SQL Server 2005...

Jonathan Crawford

12-12-2008 03:56 PM
sql_noob

I am working with SQL 2000 and have enabled the Multiphase Data Pump. I've got a function handling the insertion failure phase because I want to...

Zoe Hart

12-11-2008 02:52 PM
Zoe Hart

We have many SSIS Packages running in Jobs maintained through SSMS. I can connect to Integration Services in SSMS and see the Stored Packages in...

Peter

12-11-2008 03:21 AM
Gerald Aichholzer

I have an SSIS Package I put together on one of our servers using Visual Studio 2005. When I open the solution and run it under my login, all...

Gerhard

12-10-2008 09:26 AM
Charles Wang [MSFT]

I was wondering if anyone else was having this issue.... When I enter a data flow, some of the objects within the data flow are located off the...

Fidencio

12-09-2008 01:27 PM
Fidencio

I'm trying to modify an existing connection for a package which I call from another package using a script task. The connection string gets modified...

xyz_jat

12-09-2008 12:14 PM
Todd C

Database is SQL 2005 and Front End is in C# ---------------------------------------------------- I'm looking for a good strategy to save my data...

MS Techie

12-09-2008 09:49 AM
MS Techie

Hello, & I have an Oracle stored procedure 'osp_updateTable' that takes 4 input parameters and 1 output parameter. Iam trying to execute this...

Abba

12-09-2008 03:17 AM
Abba

Hi Everyone, I'm writing to announce a new conference: Predictive Analytics World, Feb 18-19, 2009 in San Francisco...

EliseJ

12-06-2008 11:16 PM
EliseJ

I installed BIDS 2008 on the same machine as BIDS 2005. Now whenever I try and open an SSIS package in BIDS 2005 it cause the application to close....

GorillaGirl

12-05-2008 09:26 AM
GorillaGirl

I have a stored procedure which uses sp_OAMethod to load a DTS structured storage file useing the method DTS.Package.LoadFromStorageFile. Today...

plsrob

12-03-2008 07:59 PM
plsrob

Hi all, time ago i've created some dts packages to load excel files into my db. Last week my boss asked me to adapt this packages to the...

no.mercy

12-02-2008 09:11 AM
Todd C

I am getting my feet wet in learning SSIS by taking over a somewhat complex package. My question has to do with variables. In the Script Task...

rminder

12-02-2008 09:06 AM
Todd C

Hello All, Rather new to TFS so you will have to forgive me. All of the SSIS packages that are checked into TFS open like this: Failed to...

dba

12-02-2008 09:02 AM
Todd C

I'm creating a local package in a 2000 SQL server that FTP's a flat file, transforms this data to a table in an Access database, then transforms...

Rockitman

12-02-2008 12:33 AM
Girish Nanjangud

Hi, I am very new to DTS and am currently still working with SQL Server 2000. I have two problems: 1. I need to copy a file with a daily changing...

DrDude

12-01-2008 11:33 AM
DrDude via SQLMonster.com

Hello, SQL table ======= (11) NOT NULL, NOT NULL, NOT NULL, NULL,

Abba

11-28-2008 06:11 AM
ML

Dear all I have a sqlserver 2005 sp2 built 3282 on a 64bit box. I receive an error while processing a SSAS Database out from a SSIS package with a...

Marc

11-27-2008 08:26 AM
Charles Wang [MSFT]

I had attended the PASS 2008 summit and had Rushabh give a presentation on SSIS Mgmt framework. He mentioned providing his scripts. I dont see...

RR

11-26-2008 11:31 AM
Russ Loski

Subject: Package blocked on a data conversion Hello, Here's my problem: (SSIS Package on Visual Studio 2005) In a DataFlow task,

remsrock

11-26-2008 10:42 AM
remsrock

has anybody ever used sftp to tansfer file? is there a way to do this in sqlserver 2000 and/or sqlserver 2005? thanks in advance.

lark

11-26-2008 01:50 AM
Bruce Blackshaw

I am using a DTS package on SQL2000Std to import .csv files into a staging table using a Transform Data Task and then another Data Transform and...

NH

11-25-2008 02:42 PM
NH

Folks, I've got a think-it-would-be-simple task that is really stumping me. I need to populate a flat file from SSIS with fixed length columns. In...

elvisboats

11-25-2008 09:18 AM
Todd C

Hi, I have a DTS that run weel when I run it manualy I mean when I right click on it et select Execute DTS. When I Scheduled The DTS it fails. The...

GC

11-24-2008 08:39 AM
Russell Fields

Hello, SQLserver Table - Audit_Trx ------------------ (11) NOT NULL, NOT NULL, NOT NULL, NULL, )

Abba

11-24-2008 06:25 AM
ML

I need to revert a custom object for SSIS 2008 to SSIS 2005. Some my customers doen't have the SQL Server last version. In particular, I need to...

Pasquale

11-24-2008 05:26 AM
Pasquale

Hello, I am facing an error while retrieving data from Oracle into a variable. This is the scenario: 1. I have table in Oracle and SQLServer with...

Abba

11-23-2008 11:35 PM
Abba

I would like to write a DMO/vbscript/activex control in DTS to access other DTS packages' connection objects properties. It it possible and if so...

Snake

11-21-2008 04:39 PM
Snake

Hi, I have a problem when a DTS is called by a scheduled JOB The DTS is copying Data from an Accpac dataBase by using a ODBC Data source...

GC

11-21-2008 02:08 PM
GC

I need to convert a SSIS custom component from SQL Server 2008 to 2005. In particular, I need to solve an error...

Pasquale

11-21-2008 08:35 AM
Pasquale

Hi I have the following in a dts package which picks a certain xml file and reads it into the database. It does this successfully when the path...

jojo123

11-21-2008 05:26 AM
jojo123

Hi, Can we use one xml config file for multiple packages? If yes, how can we store the different connection strings (like I have different...

xyz_jat

11-20-2008 09:09 AM
Todd C

Hi, I am trying performing a migration some data of an Oracle database to another Oracle database using the DTS, but when something occurs wrong my...

Jean

11-19-2008 11:59 AM
Jean

As far as I can tell there is no way to do a fastload or bulk insert if you need to use the EncryptByKey function on a field that is being...

MDC

11-19-2008 10:14 AM
MDC

Are there DTS improvements in Windows Server 2008 that would justify upgrading from Windows 2003 to Windows 2008? The SQL Server instance...

ggreeson

11-18-2008 09:34 AM
Russell Fields

I'm using SQL Server 2005, and need to automate running a stored procedure once a day. Used to use DTS package to do that, but that is not in...

Gerhard

11-18-2008 01:29 AM
Mark Han[MSFT]

Hi all I have a trouble with my dtsx package, these are the scenarios: - When designing my webpage I call a package by code or by command...

Don Juan

11-18-2008 01:15 AM
Sylvain Lafontaine

Hi, I created a datapump task in SQL SERVER 2000 DTS. The source for the task is stored procedure and destination is a tab delimited text file....

SRIRED

11-17-2008 04:05 AM
SRIRED

Hello, I have a DTS package containing several SQL Tasks. I would like to get all the SQL commands in a single file to edit them in an easy...

Joachim Hofmann

11-16-2008 06:58 AM
Joachim Hofmann

If I right click the local package I created in Enterprise Manager( a simple FTP download), there are options to Execute the package as well as...

Rockitman

11-14-2008 01:30 PM
Russell Fields