[font="Comic Sans MS"]

What steve has mentioned here - using Oracle password through configuration file - can be done. However - I am unable to identify the problem.

@steve-2 -...

[font="Comic Sans MS"]

Gift - what you have mentioned is correct. With advance configuration using external password store for Oracle this can be done (details below) - but this is not...

[font="Comic Sans MS"]

As bc_ has already advised - you may like to see this video for detailed steps.

http://www.sqlservercentral.com/articles/Video/64762/

[/font]

[font="Comic Sans MS"]

Sorry Pierre - somehow unable to understand it correctly. Can you please state what exactly you are trying to achieve through - I mean what is the requirement?...

dmaxj (12/18/2009)

---

I am working on pulling data from a Filemaker Pro database. I have my connection manager setup of and I can preview the data from SSIS, prior to...

[font="Comic Sans MS"]

Hi Daniel,

If I understood you correctly - the tablename from source (DB2) and tablename at destination would be same or nearly same. You can use a variable to...

[font="Comic Sans MS"]

Here is an 'always fail' is a custom script component - you can use. Simply create a script task and add the following line:

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

...

[font="Comic Sans MS"]

How are you populating the variable values : User::nom_fic_log?

[/font]

[font="Comic Sans MS"]

Yes - exactly. You wound need to decide if you wish to raise a failure or ignore the row and process the partial file. You can have a...

[font="Comic Sans MS"]

You can have a look at here : http://goo.gl/i9FU

[/font]

abhisek karki (12/17/2009)

---

I had a package that will import a data from flat file to one of sql server desintanation table, while executing the package I am getting following error

"[Flat...

[font="Comic Sans MS"]

Check this out:

http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx

or

http://www.sqlmag.com/Article/ArticleID/100005/sql_server_100005.html

or

http://download.microsoft.com/download/4/1/f/41f09116-19b3-40fe-9d54-d1e9b7af9e82/ProjectREAL_ETLDP.doc

[/font]

srikantzs (12/16/2009)

---

Hi Guys,

I too need solution to the same problem.The file names I have follow a certain pattern...

[font="Comic Sans MS"]

Here is a step by step guide on how to use transaction in SSIS - you may have a look and see if you are doing anything wrong/differently...

[font="Comic Sans MS"]

Also the packagename doesn't right to me. Note:-

1)The extension .dtsx doesn't appear for the packages stored in msdb

2)The path appears within...