Hi Scott,

Right click on the OLEDB Source and click on the Advanced Editor.

On the Advanced Editor dialog click on the Input and Output Properties tab.

Open the OLE DB Source Ouput...

BIDS saves everything as files on your local hard drive.

You would need to export the modified package to the msdb again via Integration Services.

Norman

DTS Package Search

http://www.dtspackagesearch.com/

I have found that the MS DB2 OLEDB works much better. The only issue is that you have to have SQL Server Enterprise. It still behaves badly though. I was...

They are the same in that they are UNC paths but not as far as security goes.

The C$, D$... drive$ are the administrative shares and the account that accesses them...

Use the DTSRUNUI utility to generate the command.

Great article here; http://www.sqldts.com/301.aspx

Norman

DTS Package Search

http://www.dtspackagesearch.com/

Moaen,

The unzip should occur before the foreach loop

The package should look like this:

Unzip(Execute Process Task)->Process Each csv file(ForEach Loop)

The unzip will unzip all the csv files in one step, then...

Since you are an admin use \\server\c$\dir\dir\access.mdb or what ever your path is.

But that's not really the best way. Mapped drive will work from you login on your workstation,...

It depends on how it is deployed.

Using the Integration Services service? Yes Import it into the package store again. The SQL Agent job will use the new package on the...

I use pkzip running from a Execute Process Task.

Initially I tried to use this free zip library from http://www.icsharpcode.net/OpenSource/SharpZipLib/ ,

but I could not get it to function from...

I don't understand why that will not work. I've use this in a parameterized Execute SQL Task successfully. I'll have to try it in the OLEDB Command (haven't used it...

Yes, it's the same as

if(FINDSTRING(Column,"0",1) == 1)

return RIGHT(Column,LEN(Column)-1);

else

return Column;

The ? : snytax is from the C language and maybe even something before that I am not...

Yes, reach for the script task

Here is a snippet of code that shows you how using the FtpWebRequest.

Dim ftpRequest As FtpWebRequest

...

Hi Paula,

Seems like what you are doing should work, but I've not done it that way.

What I have done in the past is to set a global variable to the...

To change it manually, double click on each access connection and click on the ... button. Browse to the new database location and clikc OK, OK.

Do you want to be...

Easy to get rid of that dangling 0x0D with a derived column transform.

Create a new column with this as the expression REPLACE(theColumn, HEX(13), "")

might need this REPLACE(theColumn, (DT_STR, 1, 1252)HEX(13),...