Derek,

Looks like you made it, but not where I was "prodding"

On the "standard" OLEDB property editor there should be four items on the Data Access Mode drop down. One of...

Yes, you are correct. The File Watcher is only for Integration Services/SQL 2005. I was just letting you know about it. It makes watching for a file simple. If you...

Hi Derek,

Is there a reason that an OLEDB source with the Oracle OLEDB privder was not used in the transformation? It has the capability to have a query as the...

Bret,

Your jobs should migrate with 0 changes. The DTSRUN is available on a 2005 SQL Server with the backward compatability pack installed. GIve it a try your self. Remote into...

TeeKay,

This can be accomplished using an ActiveX Script Task that has a script that uses that FileSystemObject to perform a directory listing. It could be done in a while loop...

Hi David,

I have no idea why, but I did check one of my packages to make sure and "Execute Task" is the 6th item on the context menu of an...

I have had this issue before and solved it by changing the format of the excel data from General to String.

Open the spreadsheet.

Highlight the column with the mixed data.

Change the...

Chris,

Where does it execute successfully in BIDS and manually? On the server or your workstation?

I've had this issue before, but I doubt it is the same. The package used an...

Alen,

Hard to say with out seeing the error, but try this.

I've not used the VB.Net & concatenation, since the String.Format became avaliable. Your error may be due to a...

Austin,

Only one instance of Integration Services per server. I have my server setup with a dev(default instance) and qa(named instance) sql servers. I have configured IS as in the article...

It works if this change is made

If CType(Dts.Variables("IsRunning").Value, Boolean) = False

Norman

DTS Package Search

http://www.dtspackagesearch.com/

Hello again Deepak,

Following up you previous post...

We use the database, since the DBAs have the correct access, they can lock it down and its gets backed up. System admins do...

Hello Deepak,

Let me suggest an alternative approach.

Perhaps a Dynamic Properties Task would help here. The file path is already in the database, so us it to set the global variable...

Drop the tables in the correct order, then there should be no issue. Start with the tables that are not parents to other tables and work you way up until...

CS,

Did you try using the REPLACE function in the derived column? If you can see the "box" you should be able to copy and paste it in the REPLACE.

Did you...