How does one read an xml data type from a sql server table into a ssis table variable or at least into a script task to allow a textwriter to convert...

vnapoli

10-31-2007 09:50 AM
vnapoli

I'm trying to run an SSIS package via a web service on my sql server. The following code is generating error DtsPipelineException -2147221005...

mystical potato

10-31-2007 05:33 AM
mystical potato

This is driving me crazy. I would like to use one of the tutuorials and sample package that microsoft offers The sample package is meant to be...

Kezza

10-30-2007 06:59 PM
Kezza

This problem is taken from an earlier post of min ebut I felt it needed to be in its own post. Is it possible to use a Global parameter passed in...

stainless

10-30-2007 06:00 PM
jhofmeyr@googlemail.com

Hi Goog question!! You have to use DTSRUN as a xp_cmdshell in a SQL Agent step to execute the package. from there you can also execute packages that...

Francisco A. Gonzalez

10-30-2007 05:51 PM
jhofmeyr@googlemail.com

I received the following error on a failed DTS package 'The number of failing rows exceeds the maximum specified. Unspecified error'. I found the...

jay via SQLMonster.com

10-30-2007 01:27 PM
Jay via SQLMonster.com

I have created an SSIS package that exports the contents of a data column into discrete files, one per record, using an "Export Column" step. Is...

PhilHibbs

10-30-2007 09:43 AM
PhilHibbs

I am trying to run an SSIS package from SQL Server 2005 Standard Edition with SP2 and I am getting the following error: 'SQLServer Error: 536,...

JackO

10-29-2007 05:19 PM
jhofmeyr@googlemail.com

I am writing a package that is dynamic based on a parameter passed in via the DTSRUN command. This needs to do the following, where the package...

stainless

10-29-2007 07:39 AM
stainless

"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