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 was familiar with the DTS object model and VB script but have little experience with the new SSIS object model and VB.net. In a package there is...
06-18-2008 04:52 AM
jhofmeyr@googlemail.com Go to last post
8 45
I have dataflow where rows are moved from OLEDB source to OLEDB destination by bulks defined in dynamically generated select statement within...
Yuriy Al
06-17-2008 09:56 AM
Yuriy Al Go to last post
48 172
Need assistance with Oracle connection in SSIS... Windows 2003 X64 SQL2005 EE X64 I've installed both 32/64bit Oracle drivers... ODBC connections...
06-16-2008 02:32 PM
Curtis Go to last post
8 77
Is there a way to create an XML destination in a data flow task? I am trying to create an XML string to pass as a parameter in a web service.
Landry, Eric
06-15-2008 10:16 PM
xantari Go to last post
10 542
Hi, in SSIS I've created a package that transforms data using several steps. I want to log each step in my table, so I've added Execute SQL tasks...
Axel Dahmen
06-12-2008 10:44 AM
Axel Dahmen Go to last post
48 162
I have a DB connection and a output destination defined in my SSIS package. What creates the output file is driven from a query that uses a view to...
06-12-2008 04:13 AM
matteus Go to last post
8 48
I tried to transfer the Packages in SQL 2000 STD to SQL 2000 Ent by Backup and Restore. It wouldn't allow and come up with error. Is there any way...
06-12-2008 03:57 AM
matteus Go to last post
8 53
hi - i'm trying to populate a sequence level variable from a script inside a data flow. I am able to 1) reference the 'variableDispenser'...
06-11-2008 03:03 PM
Todd C Go to last post
16 236
Hi, I have created a SSIS package that extracts the data from Excel (Excel 2003) to SQL Server 2005. The package runs successfully at my workstation...
06-11-2008 02:58 PM
Todd C Go to last post
8 143
Hello all, Please forgive me if I've posted this to the wrong group but I figured this was a start!! I installed SQL Server 2005 last year on my...
06-11-2008 02:41 PM
Todd C Go to last post
8 49
Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the...
06-10-2008 05:16 AM
matteus Go to last post
24 206
Hi, I am testing some import validations on dry run data that has been deliberately seeded with incorrect values to test the systems. The format...
06-10-2008 04:58 AM
matteus Go to last post
8 60
We have a web app that maintains data in a SQL server database. We need to run a monthly job that processes this data (complex logic) and then...
06-10-2008 04:17 AM
matteus Go to last post
8 97
I'm trying to bring over a text file into a SQL table, and the data has got what appears to be low values in a field on it. It's causing a problem...
Blasting Cap
06-09-2008 09:21 PM
JussiJ Go to last post
16 116
I continue to get this message though there are no duplicate keys in the table/s I am transferring into the new table I am creating using DTS....
Jay via SQLMonster.com
06-06-2008 11:33 AM
Jay via SQLMonster.com Go to last post
16 81
I have a simple SSIS package that runs a sql query that exports to a flat file, then emails this flat file to an address. I built the package in...
Carl Henthorn
06-06-2008 02:10 AM
Antoon Go to last post
8 74
I am trying to build a DTS package that exports data from SQL Server to a csv file. I am trying to use the Dynamic Properties Task to change...
06-05-2008 12:27 PM
Drew Go to last post
8 66
Thanks in advance. I have just read a post on www.sqldts.com titled "How can I change the filename for a text file connection?". The example...
06-05-2008 11:03 AM
jhofmeyr@googlemail.com Go to last post
8 46
I need help converting some existing ActiveX script to use either the Foreach or For loop task. I have a sproc that returns one row containing a...
06-05-2008 10:58 AM
jhofmeyr@googlemail.com Go to last post
50 561
I need to do a partial fuzzy lookup in SSIS. This means that some columns need to match exactly, while others are fuzzy matched. Picture an...
06-04-2008 03:54 PM
dtbascent Go to last post
16 87
I have 5 folders each having 2-3 text files. I have two DTS(SQL 2000) packages one which is having around 12 tasks which is getting processed based...
06-03-2008 06:22 PM
Ed Enstrom Go to last post
8 46
Hi All I have a DTS package which uses an "Execute Process Task" to run a BAT file which is on the server's C:\. What happens is I setup the task...
06-03-2008 01:34 PM
PittsburghCodeMonkey Go to last post
48 166
I am using an already developed DTS package that I created for a new database. Everything looks the same here. Except now I am getting this...
06-03-2008 11:31 AM
jhofmeyr@googlemail.com Go to last post
8 44
Hi, I've noticed that SSIS saves paths to configuration files as absolute paths. It does do that with the Execute Package task as well. This way...
Axel Dahmen
06-03-2008 07:08 AM
jhofmeyr@googlemail.com Go to last post
32 186
Hi, I can't possibly find any information of actually how to use a data source object or a data source view object in a package. After I've added a...
Axel Dahmen
06-03-2008 07:02 AM
jhofmeyr@googlemail.com Go to last post
24 110
Hi, I m facing the limitation of string variable (only max 4000 characters) to store my query that need > 4000+ characters. Any advice for...
06-02-2008 09:42 AM
jhofmeyr@googlemail.com Go to last post
24 123
i'm working on building a generic error handling routine for a package. I've googled my way to the point where i can iterate thru the input...
05-30-2008 12:39 PM
kent.eilers@res-direct.com Go to last post
16 99
Syntax (Multi-page thread 1 2 3 4 5 ... Last Page)
Trying in SSIS to do something which technically should be rather simple. 1) create a for each loop that contains as a variable the name of an...
05-30-2008 03:46 AM
jhofmeyr@googlemail.com Go to last post
80 307
I have two SSIS packages that import from the same flat file into the same SQL 2005 table. I have one flat file connection (to a pipe delimited...
05-28-2008 04:01 AM
Charles Wang [MSFT] Go to last post
24 102
Hope I'm in the right Newsgroup for this question. I'm sure someone will put me right if I'm not :) I'm trying to build a SQL Server 2005 SSIS...
05-27-2008 02:38 PM
alex Go to last post
16 83
Hi, I have a couples of DTS jobs set up for data import from Oracle to SQL server. They all appear to run fine when triggered manually....
05-27-2008 12:18 PM
Caoimhgh Go to last post
24 108
Hello - I have an SSIS package that runs perfectly in BIDS but when I try to schedule it as a job, it fails. Can anyone give me a place to start to...
05-27-2008 09:07 AM
Sheldon Go to last post
16 76
I created a SSIS package that imports an Excel file that has columns with > 255 chars into a SQL table. I am getting error "Text was truncated or one...
05-27-2008 08:00 AM
jhofmeyr@googlemail.com Go to last post
27 226
Hi I have a local development machine running on Windows Vista SP 1. My package ( in SSIS 2005 ) conncets to a local DB ( in dBase ) and derives a...
05-27-2008 07:58 AM
jhofmeyr@googlemail.com Go to last post
8 78
I have a csv file with first 2 lines having less columns than all the rest of the lines. The first line has 6 columns, the second line has 4...
Aki Noriko
05-27-2008 07:57 AM
jhofmeyr@googlemail.com Go to last post
8 71
Hello. I have an SSIS package, which runs fine in Visual Studio. I create and deploy the package to the SQL Server set all the connection...
05-27-2008 07:53 AM
jhofmeyr@googlemail.com Go to last post
8 44
Hi, Any idea on casting the Object type to String type in ScriptTask's Design Script area. Thank you in advance. Daniel.
05-22-2008 06:15 PM
Matthew Roche Go to last post
8 65
hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with...
05-22-2008 06:14 PM
Matthew Roche Go to last post
16 102
I have a DTS package that copies contents from an Excel spreadsheet. In the spreadsheet all columns are formatted as "text." One column consists of...
05-22-2008 09:40 AM
WhiskeyRomeo Go to last post
32 103
I have an OLE DB Source control that I am using to collect data from a stored procedure. THhe stored procedure first assembles the data in a #Temp...
05-21-2008 03:44 AM
jhofmeyr@googlemail.com Go to last post
8 39
Greetings, We have a new SQL 2005 x64 sever that runs an export which uses DTS (from 2000). One of the steps in an ActiveX script which is failing...
Tony Skalski
05-20-2008 05:02 PM
Tony Skalski Go to last post
8 62
I'm running SQL 2005 sp2 on a Windows 2003 active/passive cluster. We have some legacy DTS packages that are being called directly from a scheduled...
05-20-2008 05:26 AM
Charles Wang [MSFT] Go to last post
16 84
Does anyone know of a good book on DTS and ActiveX programming? I have the following books, Professional SQL Server 2000 Programming by Robert Vieira...
05-13-2008 10:04 AM
Terry Go to last post
8 38
I have two DTS local packages that have been running fine as scheduled jobs for years. Suddenly one of them is creating an empty output file while...
Art Cabot
05-07-2008 11:30 AM
jhofmeyr@googlemail.com Go to last post
8 70
Hi Hugo, I think the following action plan may help you out on this problem.Please understand that this is what I think might help the situation and...
Subhen Kar [MSFT]
05-06-2008 03:56 PM
Subhen Kar [MSFT] Go to last post
7 86
Currently trying to get my head around this SSIS infrastructure which is a big shock after coming from DTS. I appreciate, as a developer, that...
Rob Nicholson
05-05-2008 02:19 AM
Charles Wang [MSFT] Go to last post
24 106
I'm trying to create a scheduled job on SQL Server Agent using SMO with VB.NET 2.0. Here's a short code snippet: Dim theServer As New...
05-02-2008 03:09 PM
Eigh Go to last post
8 47
Hi, I have created an SSIS Package to import data from a DBF file, no problem. Data has been import without issue. A number of deleted records have...
Andrew Stewart
05-02-2008 02:55 PM
robert@robertdennis.com Go to last post
16 97
Hi, I'm using this query: SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' + 'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path...
05-02-2008 09:35 AM
Tomasz Borawski Go to last post
8 41
Hi THere, I am attempting to insert a constant value into a column during a DTS. Looking elsewhere on the web I found the following code that...
05-02-2008 09:23 AM
Tomasz Borawski Go to last post
8 60
Post New Thread

Display Options
Showing threads 401 to 450 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 - 2015, Jelsoft Enterprises Ltd.