"tdstr" <tdstr (AT) booger (DOT) net> wrote You can use SQL Server Integration Services for this task. SSIS is shipped with SQL Server 2005. I...

Dejan Sarka

10-28-2007 12:48 PM
Dejan Sarka

This one drove me completely nuts, When you make a change in your data source view, even if you do a Clean, then build or delete the...

dba

10-28-2007 11:40 AM
dba

Newbie question. What is the easiest method of transfering DTS packages between servers that cannot see eachother?

Cy

10-27-2007 11:16 PM
West End Computer Solutions, LLC

I am having a puzzling problem with a DTS package in SQL 2000 that uses a combination of "Execute Process Tasks" and "ActiveX Script Tasks." The...

earthStrapped

10-27-2007 11:14 PM
West End Computer Solutions, LLC

I'm writing a custom log provider that needs a connection manager to record to. The connection manager's ConnectionString is set via an expression...

Todd Beaulieu

10-27-2007 12:02 AM
jhofmeyr@googlemail.com

I am tring to convert an existing ActiveX task to a Script Task using VB.net. Below is the code from ActiveXScript (SQL 2000)? What will be the...

Rmoore

10-26-2007 11:55 PM
jhofmeyr@googlemail.com

My client is trying to create a DTS package in SQL Server 2005 to export data to a comma-delimited text file. We're trying to put double quotes...

Broadlighter

10-26-2007 02:13 PM
Broadlighter

I have an SSIS Package whereby I use the Package Configuration so I can use an XML File to store my connection details and my SSIS Package will use...

C

10-26-2007 11:19 AM
C

From a new SQL DB 'admin' trying to use SQL 2005's BI features, As a small-company 'SQL DB administrator' (still climbing up the SQL2005 learning...

pbrill1

10-26-2007 03:47 AM
jhofmeyr@googlemail.com

Hello everyone I have an SQL Server 2005 SSIS Package which users can initiate using when the use my IIS website. I kick the package off from code in...

IanHurrell

10-25-2007 05:37 AM
madhav

I am moving data from Access to SQL Server. I have a term date field (datetime) whose source values in Access are '1/1/1700' I am using an Active X...

computer.mike@hotmail.com

10-25-2007 03:37 AM
jhofmeyr@googlemail.com

I have an existing dts package that exports some data to an excel file. In the transform task, I had "created" the destination table structure...

Rob

10-24-2007 04:54 PM
Ed Enstrom

I'm trying to import data from a Lotus Notes database (*.nsf). In the middle of importing I got this error: Error at Source for Row number 3333....

lwidjaya

10-24-2007 11:21 AM
jhofmeyr@googlemail.com

I am just learning about SQL Server so please excuse what may be a silly question. I am importing the data from an Access 2000 back end database...

NevilleT

10-24-2007 07:29 AM
NevilleT

I have to export a table to an Excel file. I must generate a new Excel file every 10000 rows. Any help will be appreciated. Thanks in advance. Carmen

Carmen

10-24-2007 04:28 AM
Francisco A. Gonzalez

Does anyone use DTS or SSIS to push large volumes of data to Oracle? If so, do you have an idea of how many records you push per hour? ...

Tony

10-23-2007 08:36 AM
Francisco A. Gonzalez

I am using the upsizing tool to slq 2005 from access 2003. I have three tables which use 100's of queries. Some if the primary keys to the...

Dee

10-23-2007 07:37 AM
Dee

Hi everybody. I have this problem: A DTS that is running in SQL Server 2005 is marking an error in a job. The job's log file says about...

Ignacio Holguin

10-22-2007 08:25 PM
Ignacio Holguin

Hi, I'm the most newbie ever to SSIS. I'm a sharepoint developper who need to migrate data each week from a client submitted file to a Sharepoint...

tomypow

10-22-2007 03:11 PM
Todd C

what is the best way to store passwords and credit card information in SQL Server 2005?

dr

10-22-2007 03:07 PM
Todd C

I have a ForEach Loop with an enumerator type of Foreach File Enumerator. I would like to set the Enumerator Property Directory(Folder) using a...

Rmoore

10-22-2007 12:20 PM
Rmoore

i cannot find this library in Visual Studio 2005 when trying to add a reference. how do i get it in there? thx

rw

10-22-2007 09:05 AM
rw

Hi we have some troubles with moving our SQL2K with SP4 to SQL2K5 with SP2. In past we have used a single instance cluster (active/passive)...

Marc Bauer

10-22-2007 08:11 AM
Marc Bauer

Hi All, I'd like to create a parameterized DTS package on SQL Server 2000. Is it possible to call it from command prompt or an application with...

Kolos

10-21-2007 05:33 PM
Dan Guzman

I'm using SQL2000. I have a DTS package set up as a Job. I want to run a vbscript before it runs the DTS package. I have the order set up...

pvong

10-19-2007 11:07 AM
pvong

I am attempting to write a file to disk, based on the results of a stored procedure, but the transformations will not work. If anyone has any...

Jim Underwood

10-19-2007 09:36 AM
Jim Underwood

i have a dts package running on sql 2000 which has a 'execute sql task' task that executes a stored procedure. Is there any way i can capture the...

billu

10-19-2007 06:19 AM
billu

Hi, I am developing a number of SSIS Source, Task and Destination Components and have just started adding custom UI's to them. The UI's work as...

Jason

10-18-2007 11:05 PM
Charles Wang[MSFT]

on SQL 2005, I' m trying to run a job that execute an SSIS package. The job simply extract data from local database and dump it in an...

zino

10-18-2007 10:55 PM
Charles Wang[MSFT]

We have a dts package that monitors the error log and sends email to support personel when an error occurs. Looking for a script to deliver the...

Mohammad

10-18-2007 05:13 PM
Mohammad

Hello. I have an integration services project with a series of connections in my control flow and a data flow task in my control flow. I...

ktrock

10-18-2007 09:12 AM
Kent Tegels

Hi, I would like to import 150 different flat file in 150 different table. I would develop 150 package, but i feel that with a script it could be...

MIB

10-18-2007 08:52 AM
MIB

Hello EveryBody, I have xml document which i want to load into table using DTS and Activex Script. <?xml version="1.0" encoding="UTF-8"...

mvp

10-17-2007 02:31 PM
mvp

I created a custom log provider that works fine on my machine, but I can't get it to work on another developer's machine. I get the above message....

Todd Beaulieu

10-17-2007 11:38 AM
Todd Beaulieu

Anyone run into any problems downloading excel files through the FTP.exe process in a DTS? For some odd reason the excel files that i importing seem...

GoGoRichie

10-17-2007 08:45 AM
GoGoRichie

Is there a way to run two DTS steps at the same time? I need to speed a job up that kicks off a DTS package and in the DTS package there are many...

Chris

10-16-2007 08:08 PM
Dan Guzman

Sql2000 sp3 I created a DTS package that has 2 Global variables that I defined: gv_region string prod gv_site string nes In the Execute Sql task...

AHartman

10-16-2007 07:43 PM
AHartman

Is there a way to send a pager instead of using email task to send an email in DTS? Thank you in advance.

Mohammad

10-16-2007 07:33 PM
Todd Beaulieu

OK, my frustration level is extremely high right now. I have a package that is reading a .dtsConfig file. When I use the wizard it puts the entire...

Stephanie

10-16-2007 07:28 PM
Todd Beaulieu

I currently have an OLEDB connection manager in my package that's used by the SQL Script Tasks. I also have an ADODB.NET connection manager that is...

Todd Beaulieu

10-16-2007 07:25 PM
Todd Beaulieu

I can't figure out how to set this value at runtime. Intellisense shows no such property. Enumerating the Properties collection returns no...

Todd Beaulieu

10-16-2007 06:15 PM
Todd Beaulieu

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