Wow... a blast from the past. Yeah got it working thanks :cool:. We used a system enviro var setup on each server and each dev workstation.

This pointed to the...

yeah it works fine using a ddl statement, its more just an annoyance but was curious about it....

ramana3327 (10/8/2014)

---

Created the proxy account To run the ssis package in the job.

Before that created the new credentials and mapped to the existing login.

Login failed.

Do we need to give credentials...

any updates on this?

I'm running an ETL pulling 3 lists each with multiple columns however one has many more fields than the other 2 and that's the one which is...

Thanks for the response Phil.

I am starting to see some benefits and after we get rolling I'm sure we'll find new and clever ways to use the environments.

Also I answered...

Yes I did see the export command but to automate this that may be more of a problem, I guess it depends how much control you have over the mongo...

Not familiar with MongoDB but i'm intrigued now. Here is a possible resource:

http://docs.mongodb.org/ecosystem/drivers/csharp-community-projects/

First try to get more error info, maybe turn on some logging to get the low level message.

How are you processing the file? What does it mean that you...

this project was put on hold do to a major issue with the vendor software. we are ...

I could say something like "it's not possible to reproduce this using TSQL... well maybe with cursors" .... LOL, Just kidding Jeff 😀

The main objective of this whole project...

That is pretty interesting, I've never run into a situation where I had to do that uh well sort of.

I've used dynamically built statements within SSIS and used via...

Phillip.Putzback (10/18/2013)

---

I have stored procedure that creates a dynamic SQL command to run another stored procedure that has a column INV_STATUS.

In the internal procedure I cast that column as Numeric,...

We dont have a good solution but we do have a work around.

Basically right now we have a user that sets up jobs as themselves and once the job is...

look at dbmail instead, you want to steer clear of xp_sendmail.

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development...

I would agree with that, you could also skip database c and just overwrite database B and run the SQL statements to recreate/modify the objects that are different or dont...