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     
How can I execute a SSIS package from a stored procedure? Thank you.
Jack
05-02-2008 09:18 AM
Tomasz Borawski Go to last post
24 124
I have a DTS package that has the ActiveX Script code listed below that is used to call stored procedures in SQL Server database. The DTS package...
David P.
05-02-2008 09:13 AM
Tomasz Borawski Go to last post
8 44
Hi, We can enable memory restriction (limit cache size) for “Lookup Transformation" in Data Flow Task, can someone tell me how exactly it effects...
Manan
05-02-2008 06:31 AM
jhofmeyr@googlemail.com Go to last post
8 57
Since a local system account doesn't allow backing up to another drive, I made a new domain account so we could backup to a different drive than...
Pat M - City of Reno
05-01-2008 07:43 AM
Russell Fields Go to last post
40 114
Hello, is there a possibility to export several tables at once in csv - files? Regards Falko
Falko Schmidt
04-30-2008 07:26 AM
jhofmeyr@googlemail.com Go to last post
8 48
I have a few queries I use to locate specific text within job steps, views and stored procedures. These come in handy if you need to do a "find...
c-eric.geil@mci.com
04-24-2008 03:40 PM
nite_eagle@hotmail.com Go to last post
8 46
How can I export data between databases with different collation order (sql server 2000)??? I would like to export correctly characters such as...
Juan García
04-24-2008 08:14 AM
jhofmeyr@googlemail.com Go to last post
8 40
Hello, can someone please tell me how to set up flat file connection object when the format of the file is as follows: Date Record(s) - Fixed...
Jason
04-23-2008 09:08 AM
Jason Go to last post
72 148
Hi gang, I am having a problem and could also use some help understanding something... We have a DB in MySQL (5.0.51) that I am transferring to SQL...
Christopher Burns
04-21-2008 04:11 PM
Kevin Go to last post
16 50
I have had this problem before and I cannot seem to fix it now. There is a post with the same subject line to review. I think the solution I used is...
Jerry C
04-21-2008 03:51 PM
Kevin Go to last post
151 351
All, Using the Business Intelligence Development Studio, I migrated a DTS package from SQL Server 2000. When I run the packaged from BIDS, it worked...
cappjr@gmail.com
04-21-2008 11:55 AM
cappjr@gmail.com Go to last post
32 135
Hello, I need to import zipped text files from an ftp site. Can someone please tell me how to go about doing this? I tried the ftp task, but was...
Jason
04-21-2008 12:58 AM
Charles Wang [MSFT] Go to last post
24 91
getting this nice thing in my user acceptance test environment. The AcquireConnection method call to the connection manager "XYZ" failed with error...
Liliya Huff
04-20-2008 11:30 PM
Liliya Huff Go to last post
24 118
I'm looking for the actual files and not how to get to it in SQL 2000. I'm tyring to convert them to import them in SQL 2005 and it needs to know...
pvong
04-16-2008 10:58 AM
Bill_Orova Go to last post
8 37
I am having problems in transformation task. I am retrieving oracle data and loading into sql server table. Oracle retrieval works fine, at the time...
Ramu
04-16-2008 07:15 AM
jhofmeyr@googlemail.com Go to last post
8 49
I am using SQL Server 2000 DTS package. I am trying to re-define transformations between the source and destination tables while there are Temporary...
Justin Doh
04-15-2008 05:08 PM
Justin Doh Go to last post
8 38
Hello, I've been battling this issue since morning. Some Internet forums point out that it's some sort of a MS bug, but I couldn't find a definative...
sergei.sheinin@ru.nestle.com
04-11-2008 03:07 AM
sergei.sheinin@ru.nestle.com Go to last post
32 106
Hi, We have a new installation : SBS 2003, SQL 2005. this machine replaces a SQL 2000 installed machine. The problem we've got is that we need to...
Ian Oldbury
04-09-2008 04:37 PM
Izhar R Ab Rani Go to last post
48 131
Hello, we need to import data from AS400 to MS SQL 2000 via ODBC driver (iSeries ODBC by IBM). The trouble is with date format and using functions...
Tomas Cerny
04-07-2008 01:06 PM
Rick Brandt Go to last post
32 106
I have a DTS package failing with the error log listed below. I've never seen this before so I am not sure where to start with this one. Any...
Rubens
04-07-2008 12:45 PM
Rubens Go to last post
32 146
Hi, I'm getting following error while running SSIS package: Error: An error occurred while assigning a value to variable "variable_name":...
gojowy@gmail.com
04-07-2008 10:17 AM
gojowy@gmail.com Go to last post
16 67
Hi , We are using SSIS 2005 and have a Flat File Connection in a package. The connection is pointing to a Mapped network drive (let...
Truc H.
04-07-2008 07:10 AM
jhofmeyr@googlemail.com Go to last post
8 47
Hi all, I am very new to sql server 2005. So please bear with me. I created a couple ssis package through import and export wizard for our current...
c676228
04-04-2008 04:26 AM
Charles Wang[MSFT] Go to last post
40 112
I seem to have an oddity in importing an Excel file via DTS using SQL Server 2000. All of the information imports just fine (including 3 date...
Sean
04-03-2008 06:22 PM
Query Builder Go to last post
8 33
I run several DTS packages each day, I would like to convert from an e-mail based export system where I save the exported file locally to the...
mts
04-03-2008 09:47 AM
Truc H. Go to last post
10 137
Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS:
Francisco
04-03-2008 03:32 AM
jhofmeyr@googlemail.com Go to last post
32 99
First, sorry about the cross post but I desperately need an answer. I have a VB.Net application which uses a SQLServer DTS package which I am trying...
Andrew Baker
04-01-2008 08:37 AM
Russell Fields Go to last post
32 140
It is possible to calculate the rough size of the database based: (the size of each row + size of each index row) * no of rows Maximum row size is...
ciaran.hudson@gmail.com
03-31-2008 11:53 AM
jhofmeyr@googlemail.com Go to last post
8 36
Hi all, I am trying to manually import data manually from a txt file to a table in sql 2005 before I have a ssis package, is it possible like I did...
c676228
03-31-2008 12:16 AM
Charles Wang[MSFT] Go to last post
16 61
Hi all, Our origianl sql server 2000 database was created with COLLATE Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any...
c676228
03-31-2008 12:11 AM
Charles Wang[MSFT] Go to last post
16 59
I'm having a difficult time trying to set up a Data Flow Task that will export data into a MYSQL database. After I create the OLD DB Destination...
SpankyATL
03-30-2008 10:46 AM
doug spencer Go to last post
16 63
Gurus DTS (Multi-page thread 1 2 3 )
I need to check whithin an exists DTS source fild, i have the next code VB, but it made error message is " No match the types : 'exists' " Any help...
Fernando
03-28-2008 03:31 AM
jhofmeyr@googlemail.com Go to last post
24 76
I created a package using the import wizard in management studio. How do I modify/edit it? I read that the DTS designer need to do the job, but how...
Pingx
03-27-2008 11:03 AM
Pingx Go to last post
16 76
I have been assigned to get an EDI written for enrollment of health insurance from my HR system to a major insurance carrier; in fact, I need to...
greenmtnsun
03-27-2008 08:57 AM
jeff Go to last post
8 47
I am using SSIS to import a CSV file into a SQL table. How do I strip the double quote marks surrounding the strings in the CSV file? This seems...
jmelkerson
03-26-2008 09:34 AM
jhofmeyr@googlemail.com Go to last post
8 35
Hi, What rights does a user need to connect to the server (2005) and view/run packages from their client PC? Where are they configured? Thanks
£Jim
03-26-2008 08:08 AM
£Jim Go to last post
32 93
Hi, Please tell me whether its possible to open dts package using activeX scripts(written in VB,js etc.) or by some other means but not thru...
manu
03-25-2008 12:31 PM
nite_eagle@hotmail.com Go to last post
8 37
I've created a DTS package in SQL Server 2000 Enterprise Manager to export the data in a table that has datetime fields using Task->Export Data. ...
Andy
03-20-2008 10:01 AM
Andy Go to last post
8 29
I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is...
Rubens
03-20-2008 08:18 AM
Rubens Go to last post
8 31
Ok I am trying to create a flat file connection manager using comma delimited and " as the text qualifier. The file imports into excel properly,...
mike.mcneer@gmail.com
03-20-2008 03:55 AM
jhofmeyr@googlemail.com Go to last post
24 72
i am new to DTS. i want to clone a access database based on the value of a field that comes from the source table. Can some one provide me some Tips...
chris2383
03-20-2008 03:29 AM
chris2383 Go to last post
8 33
I'm fairly new to using SSIS, but I have learned how to download the contents of a custom database to a local development server (both with...
jrl
03-19-2008 09:57 PM
jrl Go to last post
56 152
I have migrated the DTS packages to SQL server 2005(standard) from SQL2000 using the migration wizard. The packages are under integrarion...
art
03-18-2008 08:07 AM
art Go to last post
16 53
Fri Feb 29 16:46:39 America/Los_Angeles 2008 Hi, I'd like to know how I can convert the above string to a date. Thanks in advance. Pingx
Pingx
03-16-2008 09:41 PM
lonnye Go to last post
24 63
I just ran across an interesting problem, that makes no sense. I built an SSIS package that updates a column, using an transformation script. Testing...
awakin
03-14-2008 05:19 AM
jhofmeyr@googlemail.com Go to last post
40 117
I swear there is a way in SQL 2000 to have a SQL Server Agent job (that runs a DTS) to stop running if it's been running for X minutes. I can't find...
Rich
03-13-2008 10:26 PM
lonnye Go to last post
8 28
On Mar 13, 1:48*pm, "Steen Schlüter Persson (DK)" <st... (AT) REMOVETHISasavaenget (DOT) dk> wrote: Aah - you're using an OUTPUT parameter :) I...
jhofmeyr@googlemail.com
03-13-2008 10:23 AM
jhofmeyr@googlemail.com Go to last post
23 72
I'm using expressions for some of my error handling and I need help with syntax. I need to use the replace function to remove quotes from...
Rmoore
03-13-2008 06:14 AM
Charles Wang[MSFT] Go to last post
24 74
Hi all I just ran sql upgrade advisor and got the following message: "You can use SQL Server 2005 tools to edit your existing DTS...
c676228
03-13-2008 05:38 AM
Charles Wang[MSFT] Go to last post
48 115
Hi, I'm trying to export a table to a flat file. the date column showed up like this in the flat file 2007-05-31 13:02:39.777000000 This caused a...
Pingx
03-12-2008 04:44 PM
lonnye Go to last post
8 38
Post New Thread

Display Options
Showing threads 451 to 500 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.