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...
PRW
06-18-2008 05:52 AM
jhofmeyr@googlemail.com Go to last post
8 38
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 10:56 AM
Yuriy Al Go to last post
48 171
Need assistance with Oracle connection in SSIS... Windows 2003 X64 SQL2005 EE X64 I've installed both 32/64bit Oracle drivers... ODBC connections...
Curtis
06-16-2008 03:32 PM
Curtis Go to last post
8 65
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 11:16 PM
xantari Go to last post
10 507
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 11:44 AM
Axel Dahmen Go to last post
48 157
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...
AHartman
06-12-2008 05:13 AM
matteus Go to last post
8 45
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...
Kam
06-12-2008 04:57 AM
matteus Go to last post
8 51
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'...
kent.eilers@res-direct.com
06-11-2008 04:03 PM
Todd C Go to last post
16 235
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...
LY
06-11-2008 03:58 PM
Todd C Go to last post
8 123
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...
cmw
06-11-2008 03:41 PM
Todd C Go to last post
8 46
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...
research_stuff
06-10-2008 06:16 AM
matteus Go to last post
24 203
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...
billyfix
06-10-2008 05:58 AM
matteus Go to last post
8 57
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...
mscertified
06-10-2008 05:17 AM
matteus Go to last post
8 92
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 10:21 PM
JussiJ Go to last post
16 97
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 12:33 PM
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 03:10 AM
Antoon Go to last post
8 56
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...
Drew
06-05-2008 01:27 PM
Drew Go to last post
8 53
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...
Mark
06-05-2008 12:03 PM
jhofmeyr@googlemail.com Go to last post
8 41
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...
=?Utf-8?B?Um1vb3Jl?=
06-05-2008 11:58 AM
jhofmeyr@googlemail.com Go to last post
50 490
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...
dtbascent
06-04-2008 04:54 PM
dtbascent Go to last post
16 80
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...
Nitin
06-03-2008 07: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...
Bouce
06-03-2008 02:34 PM
PittsburghCodeMonkey Go to last post
48 161
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...
PSULionRP
06-03-2008 12:31 PM
jhofmeyr@googlemail.com Go to last post
8 43
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 08:08 AM
jhofmeyr@googlemail.com Go to last post
32 174
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 08:02 AM
jhofmeyr@googlemail.com Go to last post
24 109
Hi, I m facing the limitation of string variable (only max 4000 characters) to store my query that need > 4000+ characters. Any advice for...
Daniel
06-02-2008 10:42 AM
jhofmeyr@googlemail.com Go to last post
24 115
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...
kent.eilers@res-direct.com
05-30-2008 01:39 PM
kent.eilers@res-direct.com Go to last post
16 97
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...
thejamie
05-30-2008 04:46 AM
jhofmeyr@googlemail.com Go to last post
80 291
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...
Ulysses
05-28-2008 05:01 AM
Charles Wang [MSFT] Go to last post
24 98
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...
YaHozna
05-27-2008 03:38 PM
alex Go to last post
16 75
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....
Walty
05-27-2008 01:18 PM
Caoimhgh Go to last post
24 106
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...
Sheldon
05-27-2008 10:07 AM
Sheldon Go to last post
16 75
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...
=?Utf-8?B?Uy5LdW1hcg==?=
05-27-2008 09:00 AM
jhofmeyr@googlemail.com Go to last post
27 219
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...
Webs
05-27-2008 08:58 AM
jhofmeyr@googlemail.com Go to last post
8 75
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 08:57 AM
jhofmeyr@googlemail.com Go to last post
8 67
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...
KDM
05-27-2008 08: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.
Daniel
05-22-2008 07:15 PM
Matthew Roche Go to last post
8 62
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...
lark
05-22-2008 07:14 PM
Matthew Roche Go to last post
16 97
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...
WhiskeyRomeo
05-22-2008 10:40 AM
WhiskeyRomeo Go to last post
32 101
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...
sorourke1@hotmail.com
05-21-2008 04: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 06: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...
Jason
05-20-2008 06:26 AM
Charles Wang [MSFT] Go to last post
16 81
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...
Terry
05-13-2008 11: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 12:30 PM
jhofmeyr@googlemail.com Go to last post
8 69
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 04:56 PM
Subhen Kar [MSFT] Go to last post
7 61
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 03: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...
Eigh
05-02-2008 04:09 PM
Eigh Go to last post
8 43
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 03:55 PM
robert@robertdennis.com Go to last post
16 95
Hi, I'm using this query: SET @cmd = 'BCP ' + 'Cxmain' + '.dbo.' + 'BIW_Stage_Dim_DatabaseServer' + ' out ' + @path...
surekari@gmail.com
05-02-2008 10:35 AM
Tomasz Borawski Go to last post
8 38
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...
Broonie
05-02-2008 10:23 AM
Tomasz Borawski Go to last post
8 51
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 - 2014, Jelsoft Enterprises Ltd.