Thanks for the script.

Unfortunately this script would not work.

The problem is that I reached the Initial Size that was previously incremented on 10% and I cannoyt shrink even 5mb...

So, can anybody help me with this issue???

Or there is no help available fot it???

Thanks Jessy, I understand where you are coming from.

But my db is running in a Simple Recovery Mode; I should probably mention that before.

But it still would not shrink...

Thanks for your reply Jessy. But, Im sorry this reply is for the 1st grader.

I've been in this business quite a long time. And if you read my post with...

Dear Newbie,

I spent a lot of time fighting with that problem.

The only solution that I found was this:

****************************************************************************************************

Dim oPackage, oTaskTransform

SET oPackage = DTSGlobalVariables.parent

SET oTaskTransform = oPackage.Tasks.Item("DTSTask_DTSExecuteSQLTask_1").CustomTask

' 00000 is a...

How would I build this query? Can you provide the example (script) for that.

I still think that there should be the easier way to populate the new fields from source, I...

51 Views and no answers to that one.

I'm starting to worry if there is any solution to this problem?!

Alex

Guys,

If I'm saving my excel spreadsheet in a comma delimited format and then processing it as a text file in the package it works fine.

But when I'm trying to save...

Thank you Philip,

I had this feeling that there is no way we can keep the layout of the package while modifying it programmatically.

But still nobody answered the 1st part of...

Linwood,

That is exactly what I did if you will look at one of my previous replies

Thank you Phill,

This is a nice code for replacing values in one Package.

I'm looking for a code to loop through all the packages, find a value and tell me in...

Frank,

I just made a research on this site and couldn't find anything about this issue.

But I did like the site though; thank you for mentioning it. A lot of good...

Phill,

I don't think it really matters what phrase or word you are you searching for in DTS package; in this case I was searching for '_url' string.

I probably didn't make...

Thanks Bob,

I was thinking about dts files before. But I was hoping about some magic.

Philip, I'm not the first year in this business and I know what sysdtspackages table is....

Thank you CoetzeeW,

This is a very good advise. I think that what causes the problems.

I will uncheck this option.

Alex