dbTalk Databases Forums  

Sponsored Links


microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss in the microsoft.public.sqlserver.dts forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.dts Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
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 Go to last post
0 49
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 Go to last post
0 40
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] Go to last post
80 249
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 Go to last post
0 42
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 Go to last post
8 113
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 Go to last post
8 56
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 Go to last post
8 38
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 Go to last post
16 102
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 Go to last post
0 62
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 Go to last post
8 57
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 Go to last post
16 80
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 Go to last post
0 39
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 Go to last post
8 53
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] Go to last post
24 202
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 Go to last post
8 46
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 Go to last post
24 218
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 Go to last post
0 45
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 Go to last post
8 50
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 Go to last post
0 93
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 Go to last post
0 52
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 Go to last post
0 36
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 Go to last post
8 133
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 Go to last post
16 93
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 Go to last post
8 81
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 Go to last post
16 182
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 Go to last post
8 28
Hello, SQL table ======= (11) NOT NULL, NOT NULL, NOT NULL, NULL,
Abba
11-28-2008 06:11 AM
ML Go to last post
48 430
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] Go to last post
56 241
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 Go to last post
8 145
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 Go to last post
0 148
sftp (Multi-page thread 1 2 3 )
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 Go to last post
24 164
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 Go to last post
0 32
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 Go to last post
8 53
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 Go to last post
64 187
Hello, SQLserver Table - Audit_Trx ------------------ (11) NOT NULL, NOT NULL, NOT NULL, NULL, )
Abba
11-24-2008 06:25 AM
ML Go to last post
24 88
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 Go to last post
0 40
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 Go to last post
40 279
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 Go to last post
0 38
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 Go to last post
0 137
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 Go to last post
0 60
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 Go to last post
0 74
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 Go to last post
16 72
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 Go to last post
0 164
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 Go to last post
0 65
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 Go to last post
24 187
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] Go to last post
24 100
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 Go to last post
8 56
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 Go to last post
0 62
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 Go to last post
0 40
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 Go to last post
56 361
Post New Thread

Display Options
Showing threads 401 to 450 of 12840
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.