I'm with you on this one! The wording on the question was ambiguous and I interpreted it in a way that the writer did not intend...

Yep that explains it then. Your local server will not have access to a server in the DMZ unless it's explicitly granted. You'd need to talk to whoever...

this blog may point you in the right direction

http://bi-tch.blogspot.com/2008/02/ssis-synchronousasynchronous-script.html

the major difference is that they threw out DTS and wrote SSIS from the ground up. It's completely different.

Jamie Thompson has written an excellent blog on this which may...

Jay you need to provide a lot more detail here to describe your problem.

(1) What are you trying to achieve?

(2) For what purpose to you intend to use...

Your step type on the SQL job should be SSIS Package. On the general tab, select your Package Source (being SQL or File System). Set/select the location of...

Gregory,

I just note that your post says the files are not on the 'local network'. Are the files in a different domain? or on the internet? Can you...

Brian - it sounds like your problem is different to gregory's so it might be appropriate to log your own issue rather than hijacking his 🙂

As a quick start, it...

Try running the package interactively ON the physical server (if you have access) using DTSUtil so you can see what's happening in the context of the server. This won't...

If information about you exists on the web it is in the public domain. While I may not WANT my employer or prospective employer or even my mum to...

In SQL 2000 DTS packages were always stored in MSDB. In SQL 2005, you have options. Yes you can technically store it in MSDB if you choose to...

It's not entirely clear from your post but I think the problem you are having is that you need to ignore the ExcelFilePath property and concentrate on the Connection String...

One other key difference is that Stored Procedures are stored inside a database whereas SSIS is a service that runs on a SQL server - SSIS packages are run by...

Gotta say I like using schemas for objects. The majority of objects remain dbo of course but some cases come in handy because we can group the objects and...