I have no experience of Oracle and have a little SQL Server knowledge. I am trying to connect to a Oracle 9i database managed by a (not very good)...

jrpfinch

12-11-2006 10:52 AM
nigelrivett

I have the following stored procedure that is called from the source of a transformation in a DTS package. The first parameter turns on PRINT debug...

Bill_DBA

12-11-2006 10:43 AM
Bill_DBA

Hello Mike, Are you looking for this Select * from table1 where dateopen = Getdate() Getdate() though is very specific so maybe this is too...

Allan Mitchell

12-10-2006 06:35 PM
Mike Chung

Hi Hi I have a package executed by SQLSERVER agent.It was executing fine over months now.It has failed over weekend with message. Executed as...

Usha

12-10-2006 05:16 PM
Usha

I am performing a query and an ASCII export within a DTS job. The conditions have been set for the export as Vertical line (PIPE) as the delimator...

Mike Chung

12-10-2006 05:00 PM
Allan Mitchell

Hello all, I had a problem of speed while exporting data with the management studio between 2 databases on the same SQL2005 SP1 server. I...

Matt

12-10-2006 10:36 AM
Matt

It has something to do with my workstation config, same package builds and runs fine on other boxes. Breaks when I try to build it on my...

JXStern

12-08-2006 10:30 PM
JXStern

I want to run a DTS/SSIS package from web but we do not want a full web server on the SQL box to do this but still the ability to run the DTS/SSIS...

KarenM

12-08-2006 07:18 PM
Allan Mitchell

Hi - I have a conditional split to process multiple record types in one file. The file contains a trailer record that will obviously be the last...

bigbrorpi@gmail.com

12-08-2006 07:02 PM
Allan Mitchell

Neile, On the Registered Servers explorer in SMS, notice the 5 icons directly below words Registered Servers. Click on the right icon which should...

Norman Kelm

12-08-2006 06:49 PM
Allan Mitchell

Thanks for your reply,Todd. Last night I was trying to use some data viewers. Every time I put one on a success connector, BIDS crashed. I took the...

IanO

12-08-2006 06:33 PM
Allan Mitchell

We have a production database on a SQL 2005 server. I need a copy of the data and the schema (if possible) to be copied to a SQL 2000 server we use...

Will

12-08-2006 06:30 PM
Allan Mitchell

i've been looking on this subject in this group with no luck. i've been trying to import a text file which has multiple space delimited column to a...

jesbuddy07

12-08-2006 06:23 PM
Allan Mitchell

I am using VB.net (2005) to run a dts package. I load it using oPKG.LoadFromSQLServer(sServer, , ,...

mcrisf@hotmail.com

12-08-2006 05:18 PM
mcrisf@hotmail.com

Hello Jason, I presume you are in BIDs when this happens. You should see a row count going down the error output. If you do not then no rows...

Allan Mitchell

12-08-2006 03:40 PM
Allan Mitchell

Hello E. Marsh, That error was seen a good few revisions ago and I hope you are not seeing it again http://www.sqldts.com/default.aspx?223 Can...

Allan Mitchell

12-08-2006 03:32 PM
Allan Mitchell

Todd C wrote: I am not normally a big advocate of using wizards and I think it is very possible that the problems with data typing when NOT using...

Rick Brandt

12-08-2006 01:45 PM
Rick Brandt

I have the following stored procedure that is called from the source of a transformation in a DTS package. The first parameter turns on PRINT debug...

Bill_DBA

12-08-2006 10:44 AM
Bill_DBA

We are running dts packages using dtsrun through a bat file and one of the packages that had been running fine all of a sudden when it gets done,...

Dave B

12-08-2006 10:27 AM
Dave B

Hi - I'm parsing a file that uses binary '0000 0011' / hexadecimal '03' as a row delimeter. I'm not sure how to denote this in the properties of the...

bigbrorpi@gmail.com

12-08-2006 09:31 AM
bigbrorpi@gmail.com

I have a problem, I am in the process of moving jobs and packages to SQL 2005 and I have a DTS package on SQL Server 7 that has been scheduled into a...

Jon Blues

12-08-2006 04:41 AM
Jon Blues

I wrote and deployed an SSIS package as a file system package (SQLServer 2005). I tried scheduling the package to run as a job step using SQL...

Sienna

12-07-2006 04:01 PM
Slice

I used the file system right-click, Deploy menu choice on the file ..\bin\deployment\<prjName>.SSISDeploymentManifest and 4 of the 13 .dtsx files...

Slice

12-07-2006 01:14 PM
Slice

Hello all, I am using sql2k5 bpc and need to export a comma separated files with duble quotes around each field. I got the format file going but I...

gigel

12-07-2006 10:04 AM
gigel

Hi all, I want to call stored procedure from my DTS, after execute the SQL , i want to pass the global variable to ActiveX Script. However, the...

too.changmian@gmail.com

12-06-2006 05:15 PM
Allan Mitchell

hi, i have made a package in SQL SERVER 2000 and then execute it from vb.net the source file is .txt file and the destination is sql table. now the...

san

12-06-2006 05:12 PM
Allan Mitchell

I think that should work fine in an ActiveX task actually. "Todd C" <ToddC (AT) discussions (DOT) microsoft.com> wrote

qjlee

12-06-2006 12:53 PM
TM

hi, i have made a package in SQL SERVER 2000 and then execute it from vb.net the source file is .txt file and the destination is sql table. now the...

san

12-06-2006 04:54 AM
san

Have you tried the sample code as is? Why are you creating objects? The Files collection comes from the variable, you do not need to create new...

Darren Green

12-05-2006 05:07 PM
Darren Green

Hello Yoshi_DBA, It would appear this area could mean a lot of things. A good place to start troubleshooting though is...

Allan Mitchell

12-05-2006 04:28 PM
Allan Mitchell

Here is a good question for you senior DBAs. You have to DTS 20 million rows nightly from SQL 2000 to Oracle 9.2.0. How would you do it? Here is...

TM

12-05-2006 04:26 PM
Allan Mitchell

Hello nkw, This looks like a permissions problem. The package executes so the calling code is not an issue. it is when you go to do something in...

Allan Mitchell

12-05-2006 04:22 PM
Allan Mitchell

I am running SQL Server 2005 on a clustered Windows 2003 Server. I have a very simple SSIS package that I want to run as a scheduled job. I created...

Christie

12-05-2006 03:34 PM
Christie

When I connect to Intergration Services, expand msdb folders, I can see my packages. However when use the database as in: use msdb go Select top 11...

IanO

12-05-2006 11:24 AM
IanO

Hi, I am facing a issue. I have a custom component, whose name should be localized. For this I have to read the resource file and set the Display...

DharmbirKumar@gmail.com

12-05-2006 06:43 AM
DharmbirKumar@gmail.com

Howdy! We run into a problem when we wanted to use the "Web Service Task" from SSIS (SQL Server Integration Services) to access the web...

texhex@gmx.net

12-05-2006 06:17 AM
texhex@gmx.net

Is it possible in a script task to determine if the package was started by a call from a parent package or directly from DTExec? --

GunnarKarlsson

12-05-2006 02:53 AM
GunnarKarlsson

Hi all, I am hoping that someone out there might be able to help me with a requirement we have from our client. We want to use SSIS to import our...

Jen Espana

12-04-2006 06:26 PM
Jen Espana

Hi, I have read hard through both SQLDTS.com and this forum but still can't make it work together :). My problem is trivial. I need to transfer...

alex.barvenov@gmail.com

12-04-2006 05:44 PM
Allan Mitchell

Hello, Perhaps a little off topic for DTS but I was wondering what kind of target database performance tuning I can do for a series of scheduled...

Chris W

12-04-2006 05:16 PM
Chris W

When I enabled logging on a package, I was asked to give a unc path and filename. My options were (and still are) Create File Existing file Create...

IanO

12-04-2006 05:03 PM
IanO

Hi I am trying to import a table from SQL Server 2000 (it got about 40 Millions rows) to SQL Server 2005 table, I am getting this error after...

Kalyan

12-04-2006 04:34 PM
Allan Mitchell

Hello Benjamin, I don't know whether MS intend to release an XML destination adapter. As for your solution. Why did you need to drop into temp...

Allan Mitchell

12-04-2006 01:11 PM
bchi49@gmail.com

Maybe because its Friday afternoon but I've been looking for a definitive statement on the method of specifying that this next build will be for...

IanO

12-04-2006 11:26 AM
IanO

Sorry if this isn't the right place for this but I got this problem dumped on me, and I'm more of a mainframe guy. We have a package that each...

Bruce Martin

12-04-2006 07:40 AM
Bruce Martin

hi! i'm trying to copy a database from one server to another. but still problems persist. here are the details of my servers. Server A (source) OS...

chanix yahoo

12-04-2006 12:24 AM
Arnie Rowland

I created a custom script source component to pull data from a dirty pervasive 2000i DB service pack4. Heres the problem my component will pull 425...

rhjDBA

12-03-2006 10:52 AM
rhjDBA

Hello qjlee, Once you have transferred the package it is still encrypted using the package password. How will you execute it? How do you execute...

Allan Mitchell

12-03-2006 04:36 AM
Allan Mitchell

Hello BillyRogers, Where do you see the 4.30915090000993E+15? Is it in a client tool? Is it XL? What does Query Analyser say? This looks to be a...

Allan Mitchell

12-03-2006 04:32 AM
Allan Mitchell

Hi All, I have a DTS package that transfers data from a table into excel or text files based on the option specified. But every now and then,...

cookiesncreamychoc@hotmail.com

12-01-2006 03:52 PM
Kevin3NF