| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | 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 | 1 | 132 |
|  | 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 | 0 | 92 |
|  | 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 | 9 | 148 |
|  | 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 | 8 | 119 |
|  | 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 | 2 | 127 |
|  | 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 | 1 | 140 |
|  | 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 | 1 | 130 |
|  | 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 | 2 | 156 |
|  | 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 | 0 | 92 |
|  | 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 | 1 | 128 |
|  | -------------------------------------------------------------------
:::: Great Indian Developer Summit 2009 - GIDS .Net ::::
:::: 24 April 2009...
Shaguf
|
12-25-2008 11:32 PM
Shaguf | 0 | 68 |
|  | 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 | 0 | 81 |
|  | 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 | 32 | 204 |
|  | 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 | 8 | 64 |
|  | 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 | 8 | 62 |
|  | 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 | 0 | 61 |
|  | 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 | 0 | 82 |
|  | 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] | 80 | 320 |
|  | 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 | 0 | 64 |
|  | 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 | 8 | 129 |
|  | 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 | 8 | 67 |
|  | 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 | 8 | 59 |
|  | 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 | 16 | 123 |
|  | 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 | 0 | 77 |
|  | 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 | 8 | 73 |
|  | 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 | 16 | 103 |
|  | 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 | 0 | 57 |
|  | 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 | 8 | 75 |
|  | 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] | 24 | 235 |
|  | 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 | 8 | 60 |
|  | 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 | 24 | 240 |
|  | 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 | 0 | 61 |
|  | 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 | 8 | 68 |
|  | 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 | 0 | 129 |
|  | 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 | 0 | 69 |
|  | 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 | 0 | 49 |
|  | 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 | 8 | 148 |
|  | 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 | 16 | 121 |
|  | 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 | 8 | 97 |
|  | 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 | 16 | 202 |
|  | 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 | 8 | 40 |
|  | Hello,
SQL table
=======
(11) NOT NULL,
NOT NULL,
NOT NULL,
NULL,
Abba
|
11-28-2008 05:11 AM
ML | 48 | 462 |
|  | 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] | 56 | 284 |
|  | 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 | 8 | 168 |
|  | 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 | 0 | 182 |
|  | 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 | 24 | 192 |
|  | 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 | 0 | 52 |
|  | 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 | 8 | 67 |
|  | 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 | 64 | 245 |
|  | Hello,
SQLserver Table - Audit_Trx
------------------
(11) NOT NULL,
NOT NULL,
NOT NULL,
NULL,
)
Abba
|
11-24-2008 05:25 AM
ML | 24 | 115 |