Hi all, A developer deleted one of his DTS packages from a DEV server. Unfortunately we only backup DEV weekly and his creation and deletion happened...

jaylou

10-07-2005 03:43 PM
Allan Mitchell

Hi I'm having problems on create a loop package with dynamic data sources. I have 36 databases do connect and I want to create a loop to...

CarlosR

10-07-2005 03:36 PM
Allan Mitchell

I've been reading post for about two days now, however I have not been able to find the solution. Issue: Dynamically create source and destination...

Eli Lawson

10-07-2005 03:24 PM
Allan Mitchell

Hi! I have to create a lot of complex SSIS packages that should be created automatically to save time for mapping hundreds of columns in the...

Wilfried Mausz

10-07-2005 02:26 PM
Wilfried Mausz

Hi, I develop a VB .NET application to call DTS COM to import text files into SQL Server 2000 EE SP4. We need import more than 60 files by a loop....

Bill Wang

10-07-2005 12:36 PM
Bill Wang

I have a DTS that imports data from Excel into SQL. It only works if the file name and location are exactly the same every time. I tried using...

bnhcomputing

10-07-2005 12:14 PM
bnhcomputing

I'm creating a DTS package which creates a temp table, insert some records in the temp table, export those records to an excel file and finally drop...

No_Spam

10-07-2005 10:28 AM
David J. Cartwright

Hi, When I Try to run my DTS Package I get the error: "Error string: This version of the current DTSPackage is frozen in the Repository. Its...

miguel.salles

10-07-2005 09:00 AM
miguel.salles

Hello, i use a CTP of Integration Services 2005 at the moment, to test one of our ole-db providers. This provider works almost perfectly in DTS...

Max Berghammer

10-07-2005 03:02 AM
Max Berghammer

Do you know how to execute DTS package in Store Procedure? -- shooi

shooi

10-06-2005 11:47 PM
Sue Hoegemeier

Using a DTS package, I want to use a global variable to concatinate a string for a table name I want to query. I then want to use the results as...

Steve

10-06-2005 04:50 PM
Allan Mitchell

We have a schedule that was written in Excel. It tracks all of our direct card employees (250 +), they use Comments religously to note...

Drew

10-06-2005 03:44 PM
Allan Mitchell

Hi All, Suddenly I am not able to run any DTS packages through my schedule jobs. I can run the jobs that does not have DTS package but if the job is...

Andy

10-06-2005 03:31 PM
Andy

Hi, I am using DTS to import an Excel spreadsheet into a Sql database table, but I am having trouble with one column. The table does not allow for...

Amy

10-06-2005 02:08 PM
Thomas Bradshaw via SQLMonster.com

I'm just learning about DTS Packages in my SQL Server Admin class, so please "dumb down" any responses :-D I'm experimenting with them at work...

Conan Kelly

10-06-2005 12:54 PM
Conan Kelly

Hi all, I am importing a DB2 table using DTS to a SQL server 2K5. The problem is DB2 timestamp is 10 bytes and sql datetime is still 8 bytes. what...

utpal

10-06-2005 09:16 AM
utpal

When creating a package in Integration Services, the data flow tab can use controls like "sql server destination", "OLE DB Source", and "OLE...

Mark

10-06-2005 07:50 AM
Mark

Hello, I am trying to use DTS to download certain columns from a table into a text file. Currently, the package runs once per day and I am able to...

John Lloyd

10-06-2005 07:45 AM
John Lloyd

I transform data from a DB2 table to a SQL tabel. The date format in the DB2 is in decimal 10 chr (and we need in taht format since a report...

Jarkko

10-06-2005 07:22 AM
Jacco Schalkwijk

Can the installation and uninstallation/deletion of a DTS package be scripted? I want to include it as part of an automatic installation...

McGeeky

10-06-2005 06:54 AM
Darren Green

Dear All, I have installed Microsoft OLE DB Provider for Visual FoxPro 9.0. When I do an Import in SQL2000, I can get the data source as Microsoft...

charlie

10-06-2005 01:08 AM
charlie

Hi, I have a DTS package. When I run it from a DOS prompt as following, c:>dtsrun /S sql_server /U userid /P pwd /N dts_package_name Eveything is...

Spsk

10-06-2005 12:09 AM
Spsk

I am wondering whether Trimming Varchar data is good for the space issue in database or overload (bad) for the I/O? Any suggestion?

Justin Doh

10-05-2005 06:14 PM
Allan Mitchell

I have a completed DTS package in my SQL server. The examples talk about creating and executing a DTS from VB, but no connection information is ever...

bnhcomputing

10-05-2005 05:05 PM
bnhcomputing

I am using sql query as the source of a Data Driven Query Task. I want to generate this query in an activex script task and set. but i couldn't...

Yener

10-05-2005 04:02 PM
Yener

Hi, I am running a DTS package on the local SQL Server DB to insert data from an SQL Server table (remote DB) into an Oracle table (remote DB). The...

jainamber@gmail.com

10-05-2005 03:33 PM
jainamber@gmail.com

hi all, I am importing a DB2 table using DB2. the problem is DB2 timestamp is 10 bytes and sql datetime is still 8 bytes. what are my options if i...

utpal

10-05-2005 03:06 PM
utpal

I have an activeX task that I am using and trying to write out to an Excel file. I run the task, and if I go into the file right away, it will say...

Andy

10-05-2005 02:55 PM
Allan Mitchell

Hi All Gurus I am trying to import data from FoxPro Files. i get the files in.dbf format. now when i created a link server with that file, and tryed...

Nik

10-05-2005 02:44 PM
Nik

I am importing a csv file into my SQL server 2000 DB using DTS. Is there a way that I can have the file deleted or emptied after the import is...

A.B.

10-05-2005 11:18 AM
Darren Green

Hi, I'm creating a DTS package here that is supposed to import data from an Oracle (9iR2) database into a SQL server database. I have it working...

Jens Weiermann

10-05-2005 08:54 AM
Jens Weiermann

Dear friends I have one question... I am trying to create a DTS or may be I can also create a job to be scheduled to append a table from an Excel...

Cupid Shan

10-05-2005 04:52 AM
Cupid Shan

Hi: I trying to import data using DTS. The foreign key contraints are firing because data is being inserted into child tables before parent. ...

Charlie@CBFC

10-05-2005 12:56 AM
Allan Mitchell

Hi everyone, Can someone tell me how to design my DTS to import Reference Tables (those with Primary Keys) to run in parallel. Since each Ref. table...

Calvin KD

10-04-2005 09:35 PM
Calvin KD

Hi, My DTS jobs failed first of this month(Oct 1) due to the following error.... "Step Error Source: DSO Step Error Description:Unable to connect...

Sajith

10-04-2005 06:28 PM
Sajith

Does anyone know of a tool to accurately compare DTS packages between SQL Servers? I've tried Red Gate's DTS Compare and its terrible, if it even...

MCL

10-04-2005 03:53 PM
MCL

Hi All, Suddenly I am not able to run any DTS packages through my schedule jobs. I can run the jobs that does not have DTS package but if the job is...

Andy

10-04-2005 03:28 PM
Andy

I am trying to import a table into SQL server 2000 from Progress 9. I am getting an error when trying to execute the SQL statement in the DTS...

A.B.

10-04-2005 03:13 PM
Allan Mitchell

Thanks for your reply Allan. I had tried just using Main = DTSTaskExecResult_Failure in a script on Friday, but I also had a Main...

SJM

10-04-2005 03:05 PM
Allan Mitchell

Hello Gurus, Looking for help on a problem which i need to resolve immediatly..Any help is appreciated .. Sorry if this post is too long..Trying to...

Sreejith Ram

10-04-2005 09:03 AM
sreejith.ram@gmail.com

I have developed a .NET Stored Procedure in C# (SQL 2005 sept CTP, VS 2005 RC1). 1. I'm passing an T-SQL output variable into the .NET function. For...

Per Schjetne

10-04-2005 07:32 AM
Per Schjetne

I have a package that exports a bunch of data files. For some reason, while I am in the DTS Designer, the package executes correctly - in that it...

Brandon Lilly

10-04-2005 07:03 AM
Darren Green

Hi My company has a small server cupboard and we have been having troubles with the air con unit that we have in the cupboard, the cupboard goes...

Ryan Bounds

10-04-2005 06:53 AM
Darren Green

I use DTS through other connection to connect to 2 sybase database and 1 sqlserver database. I want to transfer the data from 2 sybase database to my...

shooi

10-04-2005 04:09 AM
shooi

Hi, I created a DTS package to do some ETL task between 2 SQL servers. I want to move this package to do a similar ETL task between another set of...

atulpandey@gmail.com

10-04-2005 12:36 AM
Allan Mitchell

How is it possible to run a job on the 1st and 15th of every month? thanks -doug-

iam4msu

10-03-2005 04:55 PM
iam4msu

OK. I do realize this has been covered before for transforming from table to table. But in my case, I am parsing a text file and importing into SQL...

scott@oax.com

10-03-2005 04:39 PM
scott@oax.com

I am currently using SQL Server 2000 (sp3), I have created a DTS package which imports data from a Unix server, this works fine when I execute...

Suki Gill

10-03-2005 07:46 AM
Allan Mitchell

tat's a easier method i guess. Thanks Allan and SQL. "Allan Mitchell" wrote:

k_s

10-02-2005 11:33 PM
k_s

I want to run a DTS package and then a Stored Procedure in which i have to pass tw0 Parameters... How can i do this..?? separately i can run the DTS...

KLV via SQLMonster.com

10-02-2005 03:06 PM
knight.randy@gmail.com