I too agree with Jack, SQL Express is basically the same as SQL Standard, except Express is crippled. If you have it available there really are no downsides..

CEWII

Before I answer I want to ask you a question of my own. Why do they have to exist as files, do they change a lot, why wouldn't you...

Silverfox (9/8/2009)

---

Elliott W (9/8/2009)

---

As long as you only install the client and development tools (ie: not SQL Server, SSIS, SSRS, SSAS) then you are probably clean. BIDS doesn't require...

IF you have an SSH utility you can reference it directly with the Execute Process Task in SSIS. I see no reason to go through xp_cmdshell. You can...

As long as you only install the client and development tools (ie: not SQL Server, SSIS, SSRS, SSAS) then you are probably clean. BIDS doesn't require SSIS locally to...

I was thinking IPADDRESS,PORT

Can't remember..

CEWII

Are you referencing it by the right InstanceName?

CEWII

If you already have a job then I think the command in SQL 7/2000 is EXEC msdb.dbo.sp_addjobschedule (or something close to that)..

Not sure if that is what you are looking...

You probably need to radically up the maximum entries and the maximum entries per job.. Depending on how often your jobs run you might need to set these rather...

There's a whole lot of questions here..

1. Is SQL Sending these emails?

2. Do you expect SQL to go out to the POP3/Exchange and get the emails?

3. What is the purpose...

Not sure how to get around that on the restore. I do have a different thought. You could build a little Virtual Machine if you have the software...

How is the destination in your dataflow defined, does the last couple words in it read something like Fast Load? If not could you goto the destination and screen...

Local temp tables have always been tricky because of context. Do you have two references to the same server? Do you create the table in one and then...

Well first you need a zip component. You can try:

http://taskunzip.codeplex.com/

You can also accomplish it with SharpZipLib, 7zSharp, or SevenZipSharp libraries on CodePlex. You would probably need to add...

Well since you are already using xp_cmdshell you could use the query that gets to results and pass it to ISQL (since you are using SQL 7 or 2000). ...