Hi, I am not sure what I am missing as far as the configuration but I can not debug my SSIS package. I cna ste the breakpoints but the they are never...

Mo

07-07-2008 09:14 AM
Todd C

hi all i need to take csv files to sql server 2000 on daily basis..............can one help me how to do that....pls

sac

07-07-2008 09:07 AM
Todd C

free topliste topliste com premiere toplist kalonline topliste premiere...

sdgvfwe@yahoo.is.com

07-07-2008 04:27 AM
sdgvfwe@yahoo.is.com

I have 3 tables: Clientes Gerenciadoras ClientesGerenciadoras.. The first lists all the clientes The second the companies The 3rd is a relation...

Christiano

07-07-2008 03:44 AM
matteus

Hi I have the vbscript below in my dts package and xml schema, where I specify which sql table field the data would go into - whilst I don't get any...

jojo123

07-04-2008 09:00 AM
jojo123

anyone knows how to setup the dts run options to: Source: Server: remote auth Mode: SQL Username: xxx Password: yyy Database: bbb Destination:

Christiano

07-03-2008 06:14 AM
matteus

several of my db are returning this error... i've already unchecked the the top3 options from security... any tip??? what is this error? what...

Christiano

07-02-2008 02:48 PM
Christiano

SQL Server 2000 -- DTS Package Fails with error: Invalid procedure call or argument 'DATEDIFF'. This works in a view. Is there a better way to do...

robboll

07-02-2008 03:43 AM
matteus

Hello All! I have a DTS package that includes all records in the...

robboll

07-01-2008 01:50 PM
robboll

Hi... I have this condition: 2 SQL servers....1 local, 1 remote... Every friday I have to backup around 15 databases from the remote to...

Christiano

07-01-2008 11:33 AM
Christiano

I have a SSIS package that runs fine in Visual Studio. But if I put it in a scheduled job in SQL Server agent, it won't run. Both VS and SA use...

Irvine, Dennis

07-01-2008 11:22 AM
Irvine, Dennis

Hello there I havs ssis who transfer data between two databases. The process worked fine until i change the password on the...

Roy Goldhammer

06-30-2008 01:02 PM
Todd C

I am trying to set up a DTS package that extracts all of Yesterdays data. The code that I am using works great in a view by converting a DateTime...

robboll

06-30-2008 11:41 AM
matteus

Hi, I am using the Script manager within SSIS to execute query. Currently I have the connection string hardcoded. How do I tie the connection string...

Mo

06-29-2008 11:33 AM
Mo

Hello, I have a stored procedure to export DTS packages to files and I'd like to modify it to do same for my SSIS packages, so I have modified the...

GB

06-27-2008 12:00 PM
GB

I have a Windows Form application (not an ASP.NET app) where I would like to execute a DTS package on my local SQL server instance. The code looks...

Kirk

06-27-2008 09:26 AM
Kirk

Hi... I have a simple ssis packange. With a foreach loop I pass at the execute process one argument. This argument is a file name. The problem is the...

Anja

06-27-2008 06:03 AM
Anja

Hi, I have a problem accessing an open Textfile. I created a package to Import Logfiles from an application which creates a new log every hour. I...

Holger Voges

06-26-2008 06:22 AM
Holger Voges

Hi can u tell me how to fetch query from .sql file while working in DTS 2000? actually, I need to fetch query from . sql file(on local drive) and...

vaib

06-26-2008 02:56 AM
matteus

Hi, I have select statement in my dts package and it returns 2-3 rows for DtsGlobalVariable. So I am vbscript stuff to catch that value and use it...

John

06-25-2008 07:31 PM
John

OK, I give up. Can not figure this out. I have an Integration Services project which runs fine in VS 2005. But when I switch to the SQL server...

Irvine, Dennis

06-25-2008 05:10 PM
Irvine, Dennis

I have a DTS schedule to run every twenty minutes. It worked fine before. Now it is giving me an Access denied error when trying to open files. I...

pelican

06-25-2008 11:42 AM
ppoo

Hello All, Is there any way to transfer related tables in one Dataflow? I found a couple of articles in Internet, but they recommend using 2...

Yuriy Al

06-25-2008 03:36 AM
matteus

I have created a DTS package that exports to an excel file. The problem I am getting is that this dts package need to runs once a day and it appends...

Nigel

06-24-2008 10:51 PM
Nigel

Hello All, I have a problem with a clients station, and don't really know enough about SQL server. Here's the issue. I would attach a screenshot,...

Briantheitguy

06-24-2008 11:07 AM
matteus

I am fairly new to SSIS, but am having loads of fun... but I've run into an error that seems obvious, but I cannot seem to diagnose, and I have yet...

Joel D Kraft

06-24-2008 09:35 AM
Charles Wang [MSFT]

Hi, We have a fairly complicated set of DTS packages which are run nightly to perform our ETL process for our reporting environment. In most cases,...

Hathaway

06-24-2008 09:19 AM
Hathaway

Has anyone attempted to use DTS to open MS Project 2000 files ? If so; how did yo succeed at this. Many thanks Scotchy

Scotchy

06-24-2008 12:12 AM
Scotchy

Hi: I am getting an error when running the package from cmd line using dtexec, however, it rund fine using Execute Package Utility. In the package...

Sal

06-21-2008 12:10 PM
Maninder

Is there any Auto arrange feature or grid lines available within DTS so that I can more easily line my steps up??? Thanks in advance. PSULionRP

PSULionRP

06-21-2008 12:04 PM
Maninder

I have 2 database that perform activity then bulk insert into 1 table in a 3rd database. Is there anyway to make sure that thier is not going to be...

S

06-21-2008 12:01 PM
Maninder

I have a DTS Package where there are 4 tasks all connected to each other with OnSuccess flow , the first task is collecting all the files from...

Nitin

06-19-2008 01:21 PM
Nitin

I need to schedule a SQL Script to process and then EXPORT to .CSV file.....and then....either EMAIL out the file...OR.... FTP it to a...

Frank Xia

06-19-2008 12:20 PM
Frank Xia

Hi, My apologies if this question is not suitable to be posted here.. We are facing an issue while moving a Sql 6.5 database to a Sql 2000 server...

just55

06-19-2008 09:45 AM
matteus

Hi folks, I guess I'm having a very hard time working how this error can even arise. here's a table in SQL Server 2005 CREATE TABLE .( (10) COLLATE...

CharlesA

06-19-2008 08:55 AM
CharlesA

I have 3 SQL statements in a Execute SQL task in a DTS package. See below. There is potential for the 2nd statement to fail sometimes. When this...

Chris

06-19-2008 07:19 AM
Chris

I have a DTS Package where there are 4 tasks all connected to each other with OnSuccess flow , the first task is collecting all the files from...

Nitin

06-19-2008 04:48 AM
matteus

I was familiar with the DTS object model and VB script but have little experience with the new SSIS object model and VB.net. In a package there is...

PRW

06-18-2008 05:52 AM
jhofmeyr@googlemail.com

Hi, I am a newbie to SSIS, all I want to do is to push the xml data from a xml file into a table in SQL and I know I can do it thru' SSIS. Here is...

sweetpotatop@yahoo.com

06-17-2008 11:18 AM
sweetpotatop@yahoo.com

I have dataflow where rows are moved from OLEDB source to OLEDB destination by bulks defined in dynamically generated select statement within...

Yuriy Al

06-17-2008 10:56 AM
Yuriy Al

Need assistance with Oracle connection in SSIS... Windows 2003 X64 SQL2005 EE X64 I've installed both 32/64bit Oracle drivers... ODBC connections...

Curtis

06-16-2008 03:32 PM
Curtis

Is there a way to create an XML destination in a data flow task? I am trying to create an XML string to pass as a parameter in a web service.

Landry, Eric

06-15-2008 11:16 PM
xantari

Hi, in SSIS I've created a package that transforms data using several steps. I want to log each step in my table, so I've added Execute SQL tasks...

Axel Dahmen

06-12-2008 11:44 AM
Axel Dahmen

I have a DB connection and a output destination defined in my SSIS package. What creates the output file is driven from a query that uses a view to...

AHartman

06-12-2008 05:13 AM
matteus

I tried to transfer the Packages in SQL 2000 STD to SQL 2000 Ent by Backup and Restore. It wouldn't allow and come up with error. Is there any way...

Kam

06-12-2008 04:57 AM
matteus

hi - i'm trying to populate a sequence level variable from a script inside a data flow. I am able to 1) reference the 'variableDispenser'...

kent.eilers@res-direct.com

06-11-2008 04:03 PM
Todd C

Hi, I have created a SSIS package that extracts the data from Excel (Excel 2003) to SQL Server 2005. The package runs successfully at my workstation...

LY

06-11-2008 03:58 PM
Todd C

Hello all, Please forgive me if I've posted this to the wrong group but I figured this was a start!! I installed SQL Server 2005 last year on my...

cmw

06-11-2008 03:41 PM
Todd C

I am trying to take a ragged right text file and import into a single table. The table is flatten out so each row type will populate different...

landon

06-11-2008 09:49 AM
landon

Hi, sorry not sure if this is the right Forum for this. I am using SQL2000 SP4 and trying to set up a DTS package through Enterprise Manager however...

Kevin

06-11-2008 09:06 AM
Kevin