Hello, While trying to save package into SQL server, I'm getting the error: The SaveToSQLServer method has encountered OLE DB error code...

Gary

09-07-2007 04:49 PM
Jane

hi I must send emails every month with dynamically named files as attachments. The files are named according to the date on which they are...

nemo

09-07-2007 10:13 AM
jhofmeyr@googlemail.com

I am finally getting around to upgrading from sql 7.0. I installed a new 2005 express server for testing and am trying to use DTS wizard to move...

willjay

09-07-2007 09:36 AM
jhofmeyr@googlemail.com

I have three machine: S: Running SQL Server Express V: Running SSIS package in VS.Net F: Shared folder host excel files

=?Utf-8?B?eWRibg==?=

09-07-2007 12:00 AM
=?Utf-8?B?eWRibg==?=

My DTS package runs fine when I execute it (from Enterprise Manager) and I can open the scheduling option by right-clicking the DTS package, but it...

doug@seanyc.org

09-05-2007 05:20 PM
doug@seanyc.org

I am running a query in a DTS ExecuteSQL task. If I take that query and run it from Query Analyzer it executes OK. But executed from the ExecuteSQL...

=?Utf-8?B?c2hhcm1hbg==?=

09-05-2007 08:42 AM
=?Utf-8?B?c2hhcm1hbg==?=

Hi I have a problem regarding running a SSIS Package in a schedule Job (SQL server agent). I recently moved all my SQL server 2005 components (SQL...

=?Utf-8?B?RmlkZWxS?=

09-05-2007 04:10 AM
Charles Wang[MSFT]

Hey Guys, I have a flat file source -> it's a CSV file. I cannot seem to trap a malformed delimiter. I've tried setting the onerror conditions of...

=?Utf-8?B?TWF0dCBT?=

09-04-2007 10:18 AM
=?Utf-8?B?TWF0dCBT?=

If there's an SQL 2005 admin around, I'd appreciate an interpretation on the below error. I'm trying to deploy an SSIS package to a shared SQL 2005...

shank

09-03-2007 04:31 AM
jhofmeyr@googlemail.com

I have a data flow that I am preparing, where I am getting a list of values from a Ole DB datasource, and then I want to query a second ODBC...

=?Utf-8?B?U2Vhbg==?=

09-03-2007 04:06 AM
jhofmeyr@googlemail.com

The Error: DTExec.exe The application failed to initialize properly (0xc0000142). Click OK to terminate the application. Any ideas??? 2003SP2 -...

=?Utf-8?B?RmVkZXJpY28gTi4=?=

08-31-2007 11:30 AM
=?Utf-8?B?RmVkZXJpY28gTi4=?=

Hi there, where can I view what SSIS packages are installed on a server?

Waldy

08-31-2007 11:02 AM
Waldy

Does anyone know why when launching a package containing a child package from a SQL Server Agent job, the parent package launches correctly but the...

=?Utf-8?B?RmVydWlz?=

08-31-2007 10:16 AM
jhofmeyr@googlemail.com

When a step in my DTS Package fails, it would be nice if the actual DTS error could be e-mailed. Is this possible? How would I go about doing...

rogoflap@gmail.com

08-31-2007 09:59 AM
jhofmeyr@googlemail.com

First, let me quickly say that, so far, this is the best, most concentrated site I have found with worthwhile information concerning SSIS. Kudos to...

Bob Worley

08-31-2007 09:53 AM
jhofmeyr@googlemail.com

I have a client that is getting the error "Unable to prepare the SSIS bulk insert for data insertion". The Sql Server is the same server as the...

Mark

08-31-2007 09:34 AM
jhofmeyr@googlemail.com

There is a master package with several child packages. The encryption i have is EncryptSensitiveWithPassword. Is there a way i can set the...

=?Utf-8?B?R291dGk=?=

08-31-2007 09:28 AM
jhofmeyr@googlemail.com

I have an application that generates dts packages using vba in excel for sql 2000. Are the commands SaveToSQLServer etc.. available without loading...

=?Utf-8?B?bWljaGFlbF9sbG95ZA==?=

08-30-2007 11:42 PM
=?Utf-8?B?bWljaGFlbF9sbG95ZA==?=

I have access to a shared SQL 2005 server. So far, I cannot save my first SSIS package due to an execute permisison error. I'm assuming it's a...

shank

08-30-2007 05:41 PM
shank

I need to create a text file with data from a table. No problem, I've done that before. Then I discovered I need to select rows based upon a...

Bob

08-30-2007 02:18 PM
=?Utf-8?B?Qm9i?=

Hi I'm currently experiencing the following error when running one of my packages: Error: 2007-08-27 13:52:43.91 Code: 0xC0202009 Source:...

Frederik V

08-30-2007 10:55 AM
Russell Fields

Hi there, I have SQL 2005 Express and cannot find SSIS. I can save a package from the Import Export wizard, but cannot see anywhere where you...

Waldy

08-30-2007 10:09 AM
Waldy

My source connection is a SQL Server in SSIS and I use SQL Authentication. So I provide the user id and password in the source connection. When I...

Dora Manjula.

08-29-2007 11:58 AM
=?Utf-8?B?R291dGk=?=

Hello, I have a package that calls another package using the "Execute Package Task". When I execute the parent package from BIDS or designer, the...

=?Utf-8?B?RmVydWlz?=

08-29-2007 11:52 AM
=?Utf-8?B?R291dGk=?=

Hi, in sql 2000 DTS, there are versions i can choose from. May i know in sql 2005, the DTS version is it still available? if yes, where to locate....

=?Utf-8?B?VGlmZmFueQ==?=

08-29-2007 05:26 AM
=?Utf-8?B?VGlmZmFueQ==?=

I'm trying to set up a dts package to import data from mySQL to MSSQL 2000. I have done this on another server but on my new one, I define a source...

Nathaniel Smith

08-28-2007 05:09 PM
Nathaniel Smith

Does anyone know how to change the query timeout for an OLE DB Source in an SSIS Data Flow Task? I know this seems like a really obvious question...

=?Utf-8?B?U2ltb25EZXY=?=

08-28-2007 04:58 PM
=?Utf-8?B?U2ltb25EZXY=?=

anyone have any idea on how to do this? Thanks, Tina

tgrant29

08-28-2007 01:56 PM
tgrant29

I went through the Migration Wizard. Management -> Legacy -> Right click on Data Transformation Services. I just want to migrate a simple DTS...

=?Utf-8?B?UGF0cmljaw==?=

08-28-2007 01:00 PM
=?Utf-8?B?UGF0cmljaw==?=

I have built an SSIS package that downloads XML and CSV files via an FTP site. The package parses the raw data files and dumps them into some...

=?Utf-8?B?U2VhbiBCcm9va3M=?=

08-28-2007 10:48 AM
=?Utf-8?B?U2VhbiBCcm9va3M=?=

Hi, I'd like to filter data in the OLE DB Source node based on a variable value, to realize the function simliar to "SELECT * FROM Table WHERE...

=?Utf-8?B?RGFuaWVs?=

08-28-2007 12:43 AM
Charles Wang[MSFT]

Hi, Any one can provide information about configuring a execute package task? Thanks,

=?Utf-8?B?cWpsZWU=?=

08-27-2007 09:58 PM
=?Utf-8?B?cWpsZWU=?=

I am running a query in a DTS ExecuteSQL task. If I take that query and run it from Query Analyzer it executed OK. But executed from the ExecuteSQL...

=?Utf-8?B?c2hhcm1hbg==?=

08-27-2007 02:50 PM
=?Utf-8?B?c2hhcm1hbg==?=

I have table with that has a GUID col. I use SSIS package to do the feed and the GUID has to be provided as Param from the Config file and will be...

Awi Ktir

08-27-2007 11:32 AM
Awi Ktir

I have an environment that has just SQL 2005 SP2 (3054) installed. I have installed the most recent SQLServer_DTS feature back that supports SP2 and...

=?Utf-8?B?Um9u?=

08-26-2007 10:42 AM
=?Utf-8?B?Um9u?=

Hi. I have a simple DTS package that runs fine on a SQL 2000 server. But when I try to run it from within a SSIS parent package, it fails...

=?Utf-8?B?Q29vcA==?=

08-26-2007 10:24 AM
=?Utf-8?B?Um9u?=

Hello there For short time I've import data from one database to another using SSIS import wizart. I choosed to save the package. How can i see this...

Roy Goldhammer

08-26-2007 03:40 AM
Roy Goldhammer

The good thing is we don't have to parse the raw EDI, we are getting the data from a service that gives it to as us CSV files. The bad thing is,...

JXStern

08-24-2007 11:01 PM
JXStern

Hi, When I attempt to create a new Integrations Project I receive words to the effect 'project integration creation failed'. Under Vista, I...

Bob

08-24-2007 07:30 AM
=?Utf-8?B?VG9kZCBD?=

Predictive Analytics for Business, Marketing and Web is a concentrated training program that includes interactive breakout sessions. Sept. 20-21,...

Elise Johnson

08-24-2007 04:33 AM
Elise Johnson

Hello to everyone. I need to synchronize data between servers, where the source is SQL Server Express 2005, and the the server is SQL Server...

Manekurt

08-24-2007 03:59 AM
jhofmeyr@googlemail.com

I am an Oracle DBA. I want to learn SQL SERVER 2000 in depth (i.e. become an expert SQL SERVER DBA). Can you point any artciles/books which show...

=?Utf-8?B?UHJlbSBNZWhyb3RyYQ==?=

08-23-2007 06:12 PM
Klaus Oberdalhoff

Can use a DTS package to open an Access database, print some reports to .pdf files and then email them to a list of recipients? I would love to use...

=?Utf-8?B?SmF5?=

08-23-2007 01:56 PM
=?Utf-8?B?SmF5?=

I'm relatively new to SSIS and am getting frustrated. I have a simple Execute SQL Task that is getting an "Invalid character value for cast...

=?Utf-8?B?QWxsZW4gSC4=?=

08-23-2007 12:06 PM
=?Utf-8?B?QWxsZW4gSC4=?=

I have 2 variables, one is the column name of the table and the other one is the table name and I need to write this in the "Execute SQL task" in a...

=?Utf-8?B?R0U=?=

08-23-2007 09:36 AM
=?Utf-8?B?R0U=?=

The database servers seem to take a CPU hit whenever there is an SSIS package running. For mid-size companies, does it make more sense to setup a...

=?Utf-8?B?S2hyaXM=?=

08-23-2007 09:04 AM
=?Utf-8?B?S2hyaXM=?=

--If Execute SQL Task output is captured in XML, then errors are not reflected in the control flow (bug?!). Has anyone found a way around this? e.g....

=?Utf-8?B?Q3Jhc2ggQnVya2U=?=

08-22-2007 09:52 PM
=?Utf-8?B?Q3Jhc2ggQnVya2U=?=

I have to write a SSIS package to transfer data from production server which has about 120 databases to dev server. Each database has 160 tables and...

=?Utf-8?B?TGFtIE5ndXllbg==?=

08-22-2007 04:02 PM
=?Utf-8?B?QWxsZW4gSC4=?=

I'm trying to create an Integrated Services package to FTP MS Access data. I've run into the following problem and am at a complete halt. You have...

=?Utf-8?B?bXNjZXJ0aWZpZWQ=?=

08-22-2007 03:40 PM
=?Utf-8?B?bXNjZXJ0aWZpZWQ=?=

DTS makes it simple enough to import a text file from the local PC (e.g., C:\MyFolder\MyData.csv) when running Enterprise Manager, but how, exactly...

ksbjr@yahoo.com

08-22-2007 07:16 AM
=?Utf-8?B?QnJhdWxpbyBEaWV6?=