You are very welcome, this is a VERY common design pattern, clean the receiver, fill the receiver, then run some process to do something with the data..

CEWII

Ok, so I read that as you need to empty the destination table.

On the Control Flow of the SSIS package add a Execute SQL Task, chose the correct connection, and...

Not entirely clear what the issue is..

In your process are you needing to drop the table then load it? Or do you just need to clear the table? ...

Build a normal windows machine, provision disks to it, install SQL, copy logins and server permissions for the required logins, copy over the databases. I'm sure there is a...

Azure offers SQL Servers directly, not just the PURELY hosted database, you get a windows machine with SQL already installed.

Amazon offers a similar service.

What specifically are you looking for?

CEWII

NineIron (7/24/2013)

---

So, in my case, I have no choice but to call the vendor a dope and move on. I think I'm going to call the vendor and get a...

Eugene Elutin (7/24/2013)

---

...

While I generally agree lets not go off on a rant.. Perhaps I read that wrong, but we don't need to be testy.

As a rule you should...

Just off the top of my head you could write the audit data into a table variable, do the raiserror THEN do the insert into the base table. Table...

Eugene Elutin (7/24/2013)

---

So, if you have no choice, but to rename database (as your client/employer requires you to do), you must...

Eugene Elutin (7/24/2013)

---

NineIron (7/24/2013)

---

Thanx. So, if I were to copy a db and rename it from PROD to TEST, the sp's would run the same way on TEST without any...

Based on the original post this didn't look to be the case, but I agree in that case you might be right. I would say that if it was...

I'm pretty sure they are telling you wrong.. The USE statement is not permitted inside a stored procedure, when a stored procedure is created any use statements before it specify...

Are you running the package in BIDS on the same machine that you are trying to run it on as a job.

I have seen local firewall differences as well as...

Let me see if I read that right..

1. You have a dataflow that you want to add some data to.

2. That data is being sourced from a Script Source.

3. You...

You could use a SQL CLR routine for file access like: https://nclsqlclrfile.codeplex.com/[/url]

Please spell out the process in more detail.

CEWII