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. ...

Thanks for the outline.

I was wondering how if you had an example or knew of an example for number 3.

I haven't done that before. I would think...

This is a duplicate. I didn't even know that I had the submit button.

I would delete it if I knew how.

Sorry for the inconvenience.