John,

It worked perfectly. I just have to make a note that you can only run this on servers that are 2005 and above.

We have just a few servers still...

Markus,

Thanks for replying. It worked well.

Unfortunately, my folks here do not want to have something loaded on each production server. This script works, but you first have to...

Putting the query in the OLE DB source worked well.

That did it! Task complete.

I can now run this on all production servers and keep the results a monitoring database.

Thanks...

Well, I got that part to work.

I had to put quotes at the beginning and the end of the expression.

After that, it evaluated properly.

Now the last part:

1. Load the list...

Thanks for the help!

Here is the expression that I am using:

Data Source=@[User::CurrServer]; User ID=RptUser;Initial Catalog=MY_CUSTOM;Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False;Application Name=SSIS-Package-{44F8A456-FBBD-4165-8B66-A1E1A1D38E75}MYSERVER.MYDOMAIN.NET.MYDATABASE;

Here is the expression error message:

TITLE: Expression Builder

------------------------------

Expression cannot be evaluated.

For help,...

Alright!!!

I got it to work. Finally, I can close another task.

Thanks for pointing me in the right direction. I am still just using a script task.

Tony

P.S. Here...

Good morning,

I tried to do what you said.

1) I created a new connection manager.

2) I put a script task inside the foreach loop container.

3) I then put in a data...

Ok, so you have to just type it out and make sure you type it correctly.

Thanks. It was worth asking.

Tony

Ok, this is good. I have no idea what you are talking about, but I am learning. So this is good.

1) I am in the task script.

2)...

I have not been able to get the script task to go into break mode. In fact, I was reading a couple of articles that said you can't put...

I am working through this. Yeah.

I tend to use Visual Basic. I haven't learned C# yet.

The code I used was:

iDaysOld = CInt(Dts.Variables("User::DaysBack").Value) 'the variable DaysBack can be altered...

I tried putting breakpoints, but they didn't work.

I read somewhere that those don't work in the script editor.

The first msgbox is working to file the days.

But..

oFSO = CreateObject("Scripting.FileSystemObject")

sDirectoryPath = CStr(Dts.Variables("User::FileFolder").Value)...

Well I did look for a SSIS forum for SQL Server 2008.

I may have missed it.

Hello,

Thanks for the example. Unfortunately, corporate policy won't allow me to do any powershell coding.

That is why I was trying to do this in SSIS.

Thanks,

Tony

Hi,

Thanks for responding.

How about when you are in the script editor from the script task?

I added a script task, then went into the script editor to add some code. ...