[font="Verdana"]

Hi. My two cents and the same disclaimer as above (I am SQL Server / .NET / C# guy)

Recently had a disappointing experience as a SQL DBA in a...

Excellent article. Look forward to a follow up comparing locking and transactions between Oracle and SQL Server. That should inspire some lively discussion.

Hi folks -

Just thought I'd add a link to the vsdir file type -

http://msdn.microsoft.com/en-us/library/2sc7ft4a(VS.71).aspx

Apparently it has something to do with providing information for adding New Project...

Hi Bill

I've handled this type of processing using a separate "load control" table - which you can put in either your oracle instance or in sql server. The...

Hello

1) in the source of the data flow, use a select command instead of the table name. In the select statement you can pass column names *and* a...

Hi

I thought these templates were in -

C:\Program Files\Microsoft Visual Studio 8

\Common7\IDE\PrivateAssemblies\ProjectItems\DataTransformationProject

Hi loi

Yes. I was suggesting that you replace the 11 data flow tasks with one script task and that script task would have the code in it to...

I've never done this. But wouldn't your t-sql be select @mycount = count(*) from etc... And then you'd map the @mycount to a parameter?? I'm assuming you are...

Sounds like a good solution to me. Thanks, James.

Hi Pat

Not sure what the problem is. How are you logging?? If you're using a stream via System.IO in vb.net - then I don't know what the...

Hi - No I don't think so. What I see are 3 related tasks in the control flow. The middle one is the data flow that appends to...

Sounds like you might have to resort to a script task, using ADO.NET and the Ole db provider for Oracle. You would basically define a transaction, apply it to...

I don't think you can do that. Think the various tasks available in SSIS - especially things like file tasks, ftp tasks, etc. Because the default package protection...

How about this? In your trigger make sure that it exits immediately if the update is a multi-row update. Then in the package import into a staging table...

Do you have the package source (.dtsx or in msdb)? If so, could you turn on logging for the package in order to see what's going on? What...