Hi! I got this code from sqldts.com site and attempting to use it is giving an error: 'Object doesnt support this property or...

Test Test

10-16-2007 08:57 AM
Test Test

Hi, I have an issue with my DTS and I need some help. My global variables seem to keep the same value since the last execution. This is a problem...

jason.essebag@gmail.com

10-16-2007 08:43 AM
Todd Beaulieu

Hi: I have scheduled a DTS package (SQL Server 2000) and it is able to send an email upon completion. However, I would like to customize the subject...

Kayda

10-15-2007 11:25 AM
zk_

Hi, I am developing custom SSIS tasks and components. One of my tasks create Global Variables, Connections and a Log provider. When the code in the...

Jason

10-15-2007 10:40 AM
Jason

Hello all. I have written the below Javascript Transformation Service but for some reason it doesn't seem to work. I'm a newbie at this so...

Jon

10-15-2007 05:47 AM
Jon

Hi there I'm hoping someone can give a pointer as to issues I am having regarding SSIS configuration. I have developed an SSIS package which...

Cillian

10-15-2007 02:47 AM
Cillian

I need to connect SFTP site to download data file. Is there any way I can create a Secure FTP task in SSIS. If there is what is the best way to...

Soung

10-13-2007 02:56 PM
CozyRoc

Hi all, I am new to DTS and I need to import a CSV and save the data to and existing table. Based on primary key, I would need to filter/update...

Eugene

10-12-2007 08:33 AM
jonock14@gmail.com

I have a number of dts packages that were developed on a test server and I need to move to the live server to execute. They all reference the server...

binder

10-11-2007 08:19 AM
Todd Beaulieu

In the old days, I'd disbale tasks up front and then at runtime decide which task to "goto" and enable it and then mark it for execution. This...

Todd Beaulieu

10-11-2007 08:13 AM
Todd Beaulieu

we have a logparser-db with 600GB db-size without a primary key, ( aproximate 1500.000.000 records ) how can I add a primary key in a short time...

Mario2010

10-11-2007 07:46 AM
Mario2010

Hello, We just recentely upgraded to SQL 2005 and I'm having trouble with the Import/Export wizard failing to insert data into my guid columns. A...

dataGirl

10-11-2007 07:45 AM
Todd C

Good afternoon, I have just deployed four SSIS packages to the MSDB database. Unfortunately, when I deployed, the packages were not in the order...

Audrey Ng

10-11-2007 07:37 AM
Todd C

Hello. Running MS SQL 2000, we designed time ago a couple of DTS packages to move a lot of data from one database to another. Later after, we had to...

Alex Castillo

10-11-2007 06:29 AM
jhofmeyr@googlemail.com

Hi, We are trying to schedule a SSIS package as a job in the SQL Agent. However, we need to schedule the job dynamically. There is no fixed date...

B@ns

10-11-2007 03:27 AM
B@ns

Hello, I have a very simple situation where I want to pump data from a source SQL Server to another. If the data isn't available in the source then...

ktrock

10-10-2007 02:09 PM
ktrock

Hello Once you create (or migrate to) an SSIS package, you must get it from your BIDS onto the server before you can schedule it. One way is to...

Todd C

10-10-2007 12:39 PM
Todd C

Hi, I'm involved in a project working in a SQL Environment, let's call it SQLDB. We have to integrate in a single database data extracted from two...

david.leiva@gmail.com

10-10-2007 02:16 AM
david.leiva@gmail.com

Hi Sorry if this is a dumb question but I'm looking at ways to bulk upload data to SQL Server using VB from an application which is run on machines...

Mark

10-09-2007 04:01 PM
Mark

I am using the IBM OLE DB Provider for DB2 from SQL Server Integration Services. I can connect and read the DB2 tables with no problem. My issue is...

Borf

10-09-2007 11:30 AM
Todd C

Hi, Problem Context: I have a group of related DTS packages each one produces a single CSV file. I have another DTS package which calls each of the...

Devious Devil

10-09-2007 08:59 AM
Devious Devil

Hi, I have an Execute SQL Task in my SSIS Package. Now, this Execute SQL Task has the following query (Connection Type is OLE DB): SELECT...

B@ns

10-08-2007 11:47 PM
B@ns

Hi I have a dts package that I'm unable to open for editing. There are no problems what so ever when I try to run it. When I open for editing I get...

Andy

10-06-2007 10:24 AM
Andy

Hi, I have an automated task that runs a process to generate files and then uploads them to an FTP via WS_FTPPro and a script file. the problem in...

Nabeel

10-04-2007 05:06 PM
Darren Green

Hi, Can any one please let me know how i can join a table in one server with a table in another server using DTS. The result from the SQL...

sharancs@gmail.com

10-04-2007 10:27 AM
jhofmeyr@googlemail.com

When I tried to use the Lookup the checkboxes are not displayed on the Available Inputs they are on Available Lookups, I thought it was a datatype...

dba

10-04-2007 09:59 AM
dba

i m debuging a ssis scrit task, it s canceled, but no errors generated. i have this in the dump attached : 10/03/07 16:26:32, ACTION,...

Jomu

10-03-2007 04:54 PM
Jomu

I've been given a task and I'd like to get some feedback as to the best way to accomplish it. I have a table that is historical data from an old...

Matt Williamson

10-03-2007 03:55 PM
Jeff Boyce

Dear colleagues did anybody use sql turbo for fuzzy search , is it better than sql fuzzy search ? does fuzzy search use phonetci algorithm? what is...

Pascal Haddad

10-03-2007 11:27 AM
Hilary Cotter

Hi I'm having a DTS which will select all columns from table and export as a text file to a network share. The job is executing successfully for...

Sagar

10-02-2007 08:25 PM
Sagar

Using SSIS 2005, I am importing an excel worksheet whose column c (formatted as number) has some null values. The destination table column "c"...

michaelt

10-02-2007 07:01 PM
michaelt

We run a scheduled job with Owner: SvcExePUser. In the log after the job completes, it appears to run as US\svcClus as listed below: Executed as...

rmcompute

10-02-2007 06:20 PM
rmcompute

Hi All, I'm testing SSIS package that contains SORT transformation. The source data is an output of a VB.NET Script Component (parsing some text...

Pasha

10-02-2007 01:10 PM
Pasha

Hello Pasha, Sure, sort the data before passing it through the package. (grin) Actually though you have already identified one of the best ways to...

Kent Tegels

10-02-2007 12:10 PM
Kent Tegels

So i can't seem to figure out how to ftp files to a FTP with Dates in the titles anyone know a way of doing this?

GoGoRichie

10-02-2007 11:53 AM
GoGoRichie

any idea how to delete the physical file (C:\Test\file.txt) using DTS package.

FAHIM

10-02-2007 11:23 AM
GoGoRichie

Hello, Is it possible to pass a result of one select from SQL Execute Task to another one? I have a scenario (lets name SQL Execute Task SET to...

christof

10-02-2007 10:00 AM
jhofmeyr@googlemail.com

I have DTS package, that will import TXT file to SQL Table, it works fine when I execute package manually, but it fails when I put it on Schedule or...

FAHIM

10-02-2007 08:58 AM
FAHIM

On Sep 28, 10:38 pm, "Shane Jones" <doctorjones... (AT) yahoo (DOT) com> wrote: Hi Shane, As Andrew suggests, the best way to do this type of...

jhofmeyr@googlemail.com

10-02-2007 08:41 AM
jhofmeyr@googlemail.com

Hi, I am writing a DTS package to get data from Teradata. It seems like Teradata driver does not support parameters. I need to pass parameter to the...

Ashish

10-02-2007 08:25 AM
jhofmeyr@googlemail.com

HI friends, Using SmallDateTime in SQL Table, how can I enforce M/DD/YY format on column of type smalldatetime in SQL ServerDB. What happening is...

FAHIM

10-02-2007 07:35 AM
Russell Fields

Hello NG I use a Windows Server 2003 Web Edition standalone Server as Web Server. On this Server I have a web application running. This Web...

Roger Bavaud

10-02-2007 07:00 AM
Emra User

No idea if this is the right forum for this - could not find an SSIS forum anywhere. I'm working with this for the first time and finding it very...

mscertified

10-02-2007 04:26 AM
Kent Tegels

Has anyone successfully input an MS Access memo column into a SSIS package. I need to have this be a fixed length file and truncated to 2000...

mscertified

10-02-2007 04:18 AM
Kent Tegels

Hello, If I have to restart an SSIS package at the checkpoint, how do I keep my variable values? Is there a way to persist the variables in...

Jason

10-01-2007 10:07 PM
Peter YangMSFT]

Hello I Have a file like this: 00 070914 10 20 2625705 30 2625705070914 40 ...

jumanji

09-30-2007 05:13 PM
jumanji

Are there any samples for DTS of SQL Server 2005 data to FoxPro mdf files ? Thanks.

Chakravarthy

09-30-2007 01:47 PM
EMartinez

Hi guys, I have a performance related question about the DTS package in sqlserver 2000 which i have developed We have developed a DTS package which...

narayanan.arvind@gmail.com

09-28-2007 11:59 PM
narayanan.arvind@gmail.com

Hi Guys I hope someone can help. We have a DTS package that loads data from Oracle 9.2 into SQL server 7. Most of the time it works fine, but very...

i.galloway@vla.defra.gov.uk

09-28-2007 11:36 AM
i.galloway@vla.defra.gov.uk

Hi, I musto to migrate a database that contain 3000 tables, and if I migrate all of them, some tables have all rows migrated others (for ie all that...

Dax

09-28-2007 02:57 AM
Dax