In BIDS, so I assume in VS, there is a "Report Properties" section. In that is a tab called layout. Set your column count to 2, and you should have...

Check out the Reporting Services Web Services. You can do this programmatically... do a search on ReportExecution2005.asmx and / or ReportService2005.asmx

I apologize, but it has been a while since I have worked with DTS. I would recommend breaking up this package into sperate packages or job steps, creating the simplest...

Sorry, I missed that.

A couple of questions:

1) how do you know that the file is finished transfering when you start loading the data?

2) Can you provide the source you...

Can you provide some additional detail as to the steps within your DTS package?

What is your source? A local server (network location)? An FTP site? A drive on your SQL Server?

What is your destination? A drive on your SQL Server? A network location?

What...

Did you try logging in to the network as the SQL Server Agent account (may need to involve your DBA), right clicking the job, and see if it runs? If...

3.14159265358979323

There is the solution for pi (at least as far as I have it memorized).

Now as per the post above, instead of asking for "the solution" can you please...

If your logic is in a for each loop than if there is no objects in the array nothing within that loop will be executed (0 items = execute 0...

You can? Oooh! I got to learn something new! Thanks, Alvin, I will have to give that a try (I have never noticed that task). Come from a programming background......

foxjazz (3/14/2009)

---

Ok set this baby... Real world.

I have a table category fields are description, catID, typeID. parentID

another tables queryed with (make, model, yr, engine).

in the category table makes are typeid...

I will have to agree with Alvin on this one. You can either create an Execute Process task to move from Folder A to folder B and then create a...

I would recommend using a script task in SSIS. You can search on the FileSystemObject class... it has an Exists method for both files and folders.

After searching on the...

Try: DATEADD(ss, stime, sdate)

(and after trying be sure to lookup "DATEADD" in the Books On-Line!)

Barry,

Actually, I got around that. I created a web service that called SMO, then used the web service within my CLR function. It was not "easy", but it did work.