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     
Im trying to rename output columns in DataReader Source to be more readable. For example: in the source table is column named GLMPUJ. After...
Mirek Endys
09-24-2008 06:41 AM
Roy Harvey (SQL Server MVP) Go to last post
16 235
I'm sure the answer is no because you can't look up, only down, but I want to make sure :) I have a SQL 2000 server and a SQL 2005 server. I need...
ngan
09-23-2008 03:17 PM
Russell Fields Go to last post
40 446
What specific things have to do, that I will be able referencing my own assembly in the script editor in DataFlow ScriptComponent. I Strongly signed...
Mirek Endys
09-22-2008 10:38 PM
Charles Wang [MSFT] Go to last post
8 61
I'm running a dts (pre ssis) pkg under mgt studio/dts 2000 pkg designer and am finding that unless I open each transform individually (after opening...
steitelbaum@mhrx.com
09-22-2008 01:43 PM
steitelbaum@mhrx.com Go to last post
32 176
I am tasked with downloading from an FTP site, a flat file (an inventory of loan files) that's about 220mb large. I then rename it to a text file...
Rockitman
09-22-2008 09:49 AM
Rockitman Go to last post
32 180
Hi I am in Microsoft Visual Studio 2005 - Business Intelligence Project - SSIS package. I have my Excel data sitting in a global variable as an...
Marc in Oz
09-21-2008 06:30 PM
mpaisley@optusnet.com.au Go to last post
8 87
Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from...
Sudhakara.T.P.
09-19-2008 09:19 AM
Daniela Go to last post
10 316
Hi, I am new to SSIS. I created a pockage that extracts data from SQL and export to an Excel spreadsheet. This package will run every day. The...
Daniela
09-19-2008 08:06 AM
Daniela Go to last post
16 147
Im developing custom DataFlow Component with my own UI Editor. When I want to debug this component, I have to: 1. Uninstall old assembly from GAC 2....
Mirek Endys
09-18-2008 09:36 PM
Charles Wang [MSFT] Go to last post
8 81
Hi I am trying to learn SSIS by trail and error and I just need a little push here or pointed in the right direction :-) I have a file dump from a...
sippyuconn
09-18-2008 03:27 AM
Mark Han[MSFT] Go to last post
56 706
I have an SSIS job, SQL 2005 SP2, Windows Server 2003, that imports data from multiple databases into local SQL tables. The job imports data from...
DB
09-17-2008 12:18 PM
DB Go to last post
16 165
Hi All, I have an an ssis package with a lot of sql tasks. After finishing the first task it goes to the next and so on. All tasks on error (the red...
parez
09-16-2008 10:17 AM
parez Go to last post
16 138
Hi, I have a DTS package pointing to a database using an ODBC for Oracle. The server field is actually the database name and there is no reference...
NathanG
09-16-2008 09:55 AM
matteus Go to last post
8 195
I can not get my global variables to update. For a simple Execute SQL Task, I mapped the variable to the global variable in the Result Set page....
Marty
09-16-2008 08:05 AM
Todd C Go to last post
8 94
Im developing custom DataFlow Component with my own UI Editor. When I want to debug this component, I have to: 1. Uninstall old assembly from GAC 2....
Mirek Endys
09-16-2008 03:48 AM
Mirek Endys Go to last post
8 77
I am a SQL Server 2000 developer and recently moved to SQL Server 2005 environment. I need to know what is the equivalent of "dynamic properties...
Test Test
09-16-2008 02:10 AM
Gerald Aichholzer Go to last post
40 311
Hi, I have a DTS package that is run once a month using a text file sent to us by our customer. Each month we get a new data file and it's placed...
Jim Moberg
09-04-2008 04:44 AM
matteus Go to last post
8 60
I am running SQL Server 2000 SP4. My problem is I need to run sp_reinitsubscription for multiple publications. I try setting up a DTS that has...
Hoardling1 via SQLMonster.com
09-04-2008 04:00 AM
matteus Go to last post
8 82
Is there a tutorial on the easiest way to export an SQL Server database's tables into and Access database (all tables without having to do them one...
Gerhard
08-29-2008 03:27 AM
Charles Wang [MSFT] Go to last post
8 72
I'm doing some database maintenance by erasing DTSs and jobs that are needed anymore. I've noticed that there are jobs that don't have a...
VMI
08-28-2008 01:55 AM
matteus Go to last post
8 64
Hi, I want to move an Axapta database located on an Oracle databaseserver to a Microsoft SQL 2005 server. I would like to avoid writing an...
Kent
08-27-2008 06:04 AM
glibs Go to last post
32 284
I'm importing a CSV file into a database. The file includes a couple of date columns. I've added a Data Conversion step in my Data Flow to convert...
Aardvark
08-22-2008 01:06 PM
Aardvark Go to last post
16 161
I have an “Execute SQL Task” object in my SQL 2005 Integration Services Project. The relative properties are: ResultSet ...
Cam
08-22-2008 12:34 PM
Todd C Go to last post
8 83
I have a sql server 2000 job that is just doing an execution of a DTS pkg. When you look at the syntax in the step of the job I see something...
DTS Newbie
08-22-2008 09:12 AM
Ed Enstrom Go to last post
24 230
Hello, Is there (on internet) an official reference for the syntax to use trying to query data from an excel 2003 database in a DTS package ? here...
Roger Tranchez
08-21-2008 07:59 AM
Charles Wang [MSFT] Go to last post
24 136
hi experts, i am trying to look for answer on deploying SSIS with all connections string configuration into a SQL Database. May i know wat & how is...
Daniel
08-19-2008 07:41 AM
Todd C Go to last post
8 53
Hi, I've been trying to store a connection string in any kind of configuration. It seems SSIS never stores the password there. Do I really have to...
Axel Dahmen
08-14-2008 03:29 AM
Scho Go to last post
40 219
Hi, I have a SSIS package In my source "data flow" task I have a stored procedure (sp_GetTrafficData) which gets the data and populates the table in...
praveen
08-13-2008 11:39 AM
Todd C Go to last post
24 155
Is there anyway to set the DataRowsToSkip property at runtime? I've tried using an expression but it just gets ignored. Any suggestions are...
Brian Mahloch
08-13-2008 07:22 AM
Brian Mahloch Go to last post
16 237
I am trying to pass a value from a stored proc output variable to a user variable in SSIS. When I define the variable as integer in both SSIS and...
Jim
08-11-2008 03:47 PM
fschmid Go to last post
32 294
Hello, I've created simple SSIS package based on: http://www.sqlservercentral.com/articles/Analysis+Services/63382/ It works great from Business...
anxcomp
08-11-2008 02:49 PM
anxcomp Go to last post
24 400
I've got > 300 very complicated SSIS packages which execute TSQL and stored procedures. SSIS Packages are executed by jobs and some are...
Cqlboy
08-08-2008 07:46 PM
Cqlboy Go to last post
16 106
I have been having a hell of a time with running a dtsx package on my SQL server 2005. I designed the package on a development machine and through...
Mo
08-07-2008 10:00 AM
matteus Go to last post
8 87
HI I am only a newby with SSIS so this maybe a simple setting. I've created a solution in BI with a list of packages. i work on the solution...
nn
08-06-2008 04:45 AM
matteus Go to last post
8 61
hello, attempting to execute a dts pkg. against an MSDE 2000 engine. However, receiving the following error: Description: SQL Server does not exist...
jim
08-05-2008 06:14 PM
jim Go to last post
16 117
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 10:47 AM
Datta Go to last post
12 248
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 07:44 AM
Todd C Go to last post
64 631
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 12:36 PM
Kevin Doyle Go to last post
8 67
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 11:10 AM
matteus Go to last post
64 305
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 08:47 AM
John Peach Go to last post
8 94
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 03:27 PM
Moh Go to last post
16 196
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 10:32 AM
Gerald Aichholzer Go to last post
8 106
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 03:30 AM
matteus Go to last post
8 85
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 02:51 AM
matteus Go to last post
8 50
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 01:11 PM
briang Go to last post
24 143
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 07:41 AM
matteus Go to last post
8 56
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 01:19 PM
sastha Go to last post
14 648
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 02:05 AM
matteus Go to last post
24 184
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 07:37 AM
Todd C Go to last post
8 131
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 01:58 PM
Todd C Go to last post
8 52
Post New Thread

Display Options
Showing threads 301 to 350 of 9524
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 - 2014, Jelsoft Enterprises Ltd.