irobertson (12/7/2009)

---

Hi Elliott,

Each task is a data flow task comprising of a flat file source, a data conversion, a dervived column calculation, then an insert into a SQL Server table....

Kind of like an asynchronous trigger, that can run in any security context you want..

CEWII

Try this one:

http://msdn.microsoft.com/en-us/library/ms191126.aspx

CEWII

It is a bit more than that but that is the basis. I use "internal activation" so that I don't have to schedule another process it just pops into...

I started using it by going through the BOL tutorials. I built a queue that could realistically take jobs from any user and the receiver (which is in the...

It is kind of hard to avoid in a discussion like this..

CEWII

You can build something with service broker to get around that..

CEWII

What kind of task is the load new. I see the Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserComponent and am wondering if you are using any custom SSIS tasks. Also, silly question, are we...

I'm not sure I fully understand your question. You are using SQL Standard in a cluster, which only allows for a 2-node cluster. Are you asking how many...

When I last looked at this myself it was in some crazy format that I had to do some conversions to get it into a date/time that was usable..

CEWII

Hold on..

Let me see if I have this right.

1. Can't use xp_cmdshell

2. Want to start a batch file at a specified time

OR

2. Start it from...

I prefer to have a smaller tool that does one thing really well to a bigger tool that does a couple things well and everything else poorly or ok.. ...

Probably the easiest would be to configure your pacakge to use configurations and configure it to pull the filename from a SQL table. That way you could change the...

That is an ok email address as well. I was jsut reading those.. I will respond to them off hours..

Thanks.

CEWII

The problem with doing start|run as YOU from Server A is that it doesn't prove much.. All you have proven is YOU can do it.. If they won't...