I'm using SQL 2005 and have three databases. Live Test (Restore of Live as of June 2008) CopyOfTest I created TEST then used MS KB 871973 (How to...

Titan

01-12-2009 01:52 PM
Todd C

Hi everyone, Predictive Analytics World's program for Feb 18-19 in San Francisco (www.predictiveanalyticsworld.com) has grown a bit since my...

EliseJ

01-11-2009 01:38 AM
EliseJ

Have SQL 2000 and wish to export only a row of data from a particular table but not the whole table itself. Once this is completed then we want...

Transam388

01-09-2009 08:00 PM
sql_noob

I am trying to deploy a SSIS package from my computer to a server that is being built to replace an existing server. When I run the .manifest...

Snowmizer

01-08-2009 03:49 PM
Snowmizer

When I execute the Transfer Logins Task I get the following error: " Error: Execution failed with the following error: "Windows NT user or group...

Kelly

01-08-2009 09:41 AM
Kelly

I need to pull a table from one server into another for testing purposes. I have a linked server setup from server A to server B and I run a query...

GPage

01-08-2009 09:19 AM
Russell Fields

Hello Everyone, I am trying to learn SSIS. I have Visual studio 2005 on my computer and Sql server 2005. when I go to programs->Microsoft SQL server...

Vinki

01-08-2009 09:13 AM
Paul Ibison

Hi All - new boy here and happy New Year to you... I have a problem I could do with some pointers on. I have an SSIS package to consume a Web...

Paddy

01-08-2009 05:49 AM
Paddy

Ydinalan disinformaatiosyydössä huomaa aiheen synnyttämän panikin. Totuus ei heitä miellytä. Mutta koska haluan varmistaa aina KAIKEN...

Niklas Räsänen

01-05-2009 10:47 PM
Niklas Räsänen

I am trying to run a SSIS package from Visual Studio on my machine. This package is to connect to a database but I am getting this error: The...

ronnie

01-02-2009 08:28 AM
Todd C

------------------------------------------------------------------- :::: Great Indian Developer Summit 2009 - GIDS .Net :::: :::: 24 April 2009...

Shaguf

12-25-2008 11:32 PM
Shaguf

Hi, Any idea on using schtasks.exe in BAT file to auto-executing the SSIS? I have issue in putting the value after /TR as below: "C:\Program...

Daniel

12-25-2008 08:48 PM
Daniel

Hi! I currently use conesans checksum component, but I need a md5-checksum pushed into a bigint (I believe conesans uses crc-32). Has anyone solved...

Gorm Braarvig

12-25-2008 04:15 PM
Gorm Braarvig

We are currently planing on migrating from SQL server 2000 to SQL Server 2008. I have read that DTS packages will work in SQL Server 2005 but I can...

Toni

12-24-2008 10:49 AM
Russell Fields

Hello, Iam syncing data from PROD to BETA using an SSIS package. After I load the data to stage table from PROD, I compare the dates between stage...

Abba

12-24-2008 06:30 AM
Tom Moreau

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 05: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 10: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 12: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 01: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 12: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 09: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 07: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 12: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 05: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 04: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 02: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 01: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 02: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 08: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 12: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 11:14 AM
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 08: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 02: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 10: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 08: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 06: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 08: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 08: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 08: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-01-2008 11:33 PM
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 10:33 AM
DrDude via SQLMonster.com

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

Abba

11-28-2008 05: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 07: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 10: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 09: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 12: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 01: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 08: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 07:39 AM
Russell Fields

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

Abba

11-24-2008 05:25 AM
ML