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     
I have a simple table with five columns. One of the column is a date. When I import the data into a datetime field I get the error: An OLE DB...
robboll
07-06-2010 05:52 AM
Gorm Braarvig Go to last post
2 153
I'd like update a parameter with the SQL Query Property (or the select statement of the source table) in an SSIS Task. Does anyone have any...
jm27102
07-01-2010 09:19 AM
jm27102 Go to last post
0 42
Hi! I have a table with 3M records on an ORACLE DB. A record can fit about 300K Bytes. Don't ask me why, this was not my design. I am trying to...
Jose
06-29-2010 11:49 PM
Geniusinuse Go to last post
1 60
Predictive Analytics World Conference – October 19-20, 2010 - Washington, DC Dates: October 19-20, 2010 Location: Washington,...
EliseJ
06-28-2010 01:34 PM
EliseJ Go to last post
0 38
Hi! I have a table with 3M records on an ORACLE DB. A record can fit about 300K Bytes. Don't ask me why, this was not my design. I am trying to...
Jose
06-21-2010 08:21 PM
Jose Go to last post
0 33
Hello, i want to backup my mssql server 2005. is there any way to backup sql database to txt, doc, xls etc.. format? not .bak file format. thanks
gulerayh
06-18-2010 06:12 AM
Paul Shapiro Go to last post
1 57
Hi all, i hope this is an easy question... i have an SSIS package that tries to do step A. if that fails, we have it set to on-failure do step...
Joe Sampino
06-17-2010 11:32 AM
Joe Sampino Go to last post
0 41
I am trying to use "OLE DB Source" for SQL Server and "DataReader Destination" for AS400. If I do other way, from AS400 to SQL Server, I was able to...
Justin D.
06-15-2010 05:24 PM
Justin D. Go to last post
0 40
Hello SSIS Gurus! I am putting together an SSIS job that dumps and repopulates a delimited record source nightly, but there is nothing in the data...
robboll
06-15-2010 05:06 PM
robboll Go to last post
0 35
We have SaveCheckpoints set to True. In a script block we are converting the Recordset to a DataSet using the following sample code. If we...
bsk_WF
06-15-2010 04:41 PM
bsk_WF Go to last post
1 33
I have a DTS package with Transformations that look like this: Function Main() DTSDestination("PART_PAY_PAYMENT") =...
robboll
06-14-2010 04:20 PM
robboll Go to last post
0 40
Hi, I am trying to run an SSIS package from SQL server agent. The package has one script task that uses an ADO connection. When running the package...
shnel
06-11-2010 07:45 AM
Bernardo Romero Go to last post
5 194
Hi, trying to run an SSIS package (SQL 2008) using the 32bit DTEXEC (due to 32bit Oracle client) on Windows 2008 64bit with 64GB of RAM. The...
Landry
06-10-2010 09:10 PM
Landry Go to last post
0 33
Am running in BIDS using the SQL 2005 SSIS sharepoint list source and destination source to identify the doc lib. Have a test doc lib setup with...
HaroldH
06-10-2010 09:26 AM
HaroldH Go to last post
0 40
Is it possible to use variables that are specific to a sequence container only ? Variables are available in the Control Flow and Data Flow Task areas...
jm27102
06-08-2010 11:14 AM
jm27102 Go to last post
0 45
Hi, I am having a strange issue while setting up package configurations. First, I have set up an environment variable with the below value: Data...
Neeraj
06-07-2010 04:18 PM
Neeraj Go to last post
0 32
I'm a newbie to SQL Server 2008 Integration Services (I have done some DTS packages in SS 2000) and I was wondering why the Fuzzy Lookup component...
Crazy Cat
06-07-2010 10:31 AM
Crazy Cat Go to last post
0 35
Hi there, I'm using SQL Server 2008 And I have a table called myProgress with column name summary data type xml looks like that <?xml...
odeddror
06-05-2010 02:58 PM
odeddror Go to last post
0 45
Our nightly datawarehouse update processing is periodically failling on an irregular basis. No useful errors in Windows logs, SQL logs, or SQL...
dworxClint
05-28-2010 10:31 AM
Carla Sabotta Go to last post
1 137
Any idea how to diagnose a timing out error? Sometimes it happens when the package just starts running, other times after it has processed thousands...
Dorian
05-27-2010 04:44 PM
Dorian Go to last post
0 55
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft...
nntp@microsoft.com
05-21-2010 04:54 AM
nntp@microsoft.com Go to last post
0 69
We are having a strange problem with a DTS package running on SQL 2005 after our upgrade from SQL 2000 this week. The first step of the package just...
Jason Fisher
05-20-2010 10:55 AM
Jason Fisher Go to last post
0 73
I am very new to SSIS 2005 I have a sql command Select count(*) from table_a. The result is stored in a global variable. In a script task, if the...
The Other Mike
05-18-2010 07:45 AM
Todd C Go to last post
1 109
I am using SSIS 2005 to import a text file, do some lookups and then send the output to subfolders on the destination hard drive based on certain...
imani_technology_spam@yahoo.com
05-13-2010 10:46 AM
Todd C Go to last post
1 99
Hi all, been working on this problem for a while now but having little success finding a satisfactory solution. I have a DTS package which contains...
VegaLA
05-10-2010 04:41 PM
VegaLA Go to last post
0 77
Ok Gurus, Here is an interesting situation, I have a coworker that has a flat file with no column headers that needs to be imported or appended into...
Bill Orova
05-05-2010 03:49 PM
Todd C Go to last post
1 153
What could go wrong here? I created a simple DTS Package to copy one DB from server A to server B using the Copy Database Wizard. The Package is...
David
05-03-2010 03:56 AM
David Go to last post
0 71
I have some scheduled dts packages. They error out with this message every time. I can run the package manually with no problem. Step 'Copy Data...
Leslie
04-29-2010 09:51 AM
Gaurav Go to last post
4 290
Hi -- MS SQL2008. I want to export a table1 to MS Access so I using Export data. While it is exporting to the last step I got an error " OLE DB Size...
MN
04-29-2010 07:50 AM
Todd C Go to last post
1 77
I'm getting "The Data Pump Task requires Transformations to be specified" error. The package has everything specified correctly. The package was...
Dorian
04-26-2010 05:48 PM
Dorian Go to last post
0 88
Hi I have a really simple DTS package that loads a .csv into a table using a Transform Data Task. Very occasionally, I get a primary key violation...
NH
04-23-2010 07:28 AM
Paul Shapiro Go to last post
1 145
I’m having difficulty figuring out why the sample HelloWorld custom task is not showing up inside of BIDS (SSIS Data Flow Items tab). I’ll be...
Dave
04-16-2010 06:24 PM
Dave Go to last post
0 88
We have DTS package with isolation level of 'read commited'. In this is a vbscript task that opens a recordset and loops through it. Question: is it...
Dorian
04-15-2010 04:12 PM
Dorian Go to last post
0 89
Hello all, I have a execute sql task in a container with other tasks. This is all the task has in it DECLARE @RC int EXECUTE @RC = ...
William E. Booth
04-09-2010 05:06 PM
William E. Booth Go to last post
3 167
I am executing a sql file through dts. Is is possible to get complete sql execution log (i.e. so many rows updated etc.) and not just step failure...
pradeep
04-08-2010 10:05 AM
Zodiac Go to last post
7 199
SSIS Community: I have some .txt files I need to work with in SSIS. When I create a Flat File connection, the connection manager does not seem to...
JJ of Eugene OR
04-05-2010 11:13 PM
SQL Lion Go to last post
12 509
I am converting a simple (at least in the SQL Server 2000 DTS days) to this new SSIS. I have a data source (which is Oracle 8 using .Net ODBC...
cindy
04-01-2010 03:41 PM
Doug Ivison Go to last post
11 470
Hi I want to edit a query that I pasted into the DTS package when running the import wizard. Is there a way to do this without having to rerun the...
Mitchell_Collen via SQLMonster.com
03-31-2010 01:12 PM
Mitchell_Collen via SQLMonster.com Go to last post
0 89
In order to copy all files in certain folder to another folder (with the same file name) I have placed a File System Task inside the foreeach...
rkbnair
03-30-2010 02:15 PM
Joshi Go to last post
81 408
Hi Guys, I'm currently using SSIS to copy data from a source table, change some of the datatypes and pump it into a destination table. The problem...
lloyddsilva@gmail.com
03-30-2010 08:04 AM
sneha Go to last post
3 132
Hi - I'm not familar with DTS deatils. I was wondering if Microsoft has a tool in either SQL 2k5 or SQL 2k5 SSIS which "converts" SQL 2k DTS...
Steve M
03-30-2010 07:36 AM
Todd C Go to last post
1 89
Hopefully someone can help me with this. I have an SSIS package that runs great in all my environments. However, this package recently stopped...
Chris
03-29-2010 04:05 PM
Ricky Hall Go to last post
10 478
I'm (attempting to) converting a legacy Perl program to SSIS. The apps purpose is to sign in to a web service, submit a request and receive an...
Peter
03-29-2010 11:29 AM
Peter Go to last post
0 82
Is there a way for a DTS script (vbscript) to tell which server it is running on? Is there any reason I cannot set a variable using this technique...
Dorian
03-24-2010 11:09 AM
Dorian Go to last post
0 131
How are DTS packages normally promoted from development to test and test to production? I need to update a DTS package, both the number of steps in...
Dorian
03-24-2010 09:23 AM
Dorian Go to last post
2 99
Hi, I have a problem which is causing us grief and we don't know where to look next. We have an SSIS package. The said package runs at an acceptable...
Kevin
03-23-2010 06:44 AM
Todd C Go to last post
1 101
Hi, I am having a problem doing a quick and dirty export from a table to a csv file. It is not a job just a quick run, never experienced this...
Brian
03-23-2010 06:40 AM
Todd C Go to last post
1 98
I am using SQL Server 2005 and trying to import a CSV file on the web. I am not a programmer so I was just trying to use the import and export...
RedGlow06 via SQLMonster.com
03-19-2010 04:05 PM
greenmtnsun Go to last post
1 179
So if we created a an OLE DB Source with this SQL select field_1, field_2, field_3 from table_1 For XML AUTO It would create xml results from the...
Hotwheels
03-18-2010 11:31 AM
Hotwheels Go to last post
0 83
Please advice on How to Execute a DTSX package from VB.Net 2003.
chiks81
03-18-2010 05:45 AM
Todd C Go to last post
1 90
Post New Thread

Display Options
Showing threads 1 to 50 of 12806
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 - 2010, Jelsoft Enterprises Ltd.