msbi.ravindhar (12/13/2015)

---

I have been asked to do a task which is import data from one table and loop through that data with another table and fetch the matching result using...

Not long before the weekend!

As far as I know, there is no standard SSIS task which does this. Are you using third-party tools?

You should be able...

If you are open to using SSIS, most definitely.

Except for one thing. If you have an ISO language table, there is no need to invent an int PK - use the ISO code instead.

Yes, exactly right.

hazeleyre_23 (12/10/2015)

---

Hi,

How do I get the date to change if the time someone works goes past midnight.

i.e if someone works 21:00 - 06:00.

I have a roster date column, start shift...

Also, note that SSIS is not really suitable for 'run-time prompting' as it is intended to run unattended on a server.

Another thumbs up for SQL Prompt Pro from me.

SSMS Boost has some features which I also use frequently:

1) Connection shortcuts. Define connections to different databases on different servers and from...

It may be of interest to other forum members to know how you solved your problem. I'm guessing you did something like

With (your original query)...

If you know that ; is a terminator and then deliberately use it as an initiator, it is an indication that you are not interested in getting the little details...

Leave the package exactly as is,...

It's not a scenario I've had to deal with. However, I would have expected it to run just fine, assuming you have the connection string to the new server properly...

If my message sounded sarcastic, I apologise. That was not my intention.

BrainDonor (11/27/2015)

---

A simple issue, but I'm not having much success.

Could somebody have a look at http://www.sqlservercentral.com/Forums/Topic1740538-391-1.aspx#bm1740579 please?

Either the driver they're using doesn't allow some the solution I'm suggesting, or...