You could think of each of these as a service, that service is still a product. Even if it is a unwanted good, it still generated a line item of...

Thanks for your responses. I am also looking for a good resource on WQL, if anyone has any suggestions.

Thanks.

Thanks Ells. I will try that suggestion, using a script task with a variable. I was just curious if there was some issue with the query I have and why...

True...

What version of Excel are...

Hi,

Is there any one that can offer any advise?

It would be much appreciated. Thank you 🙂

I was thinking also there are times when a business would get accounts from a client with the client's key (account #)for that account. You would create your own...

Phil Parkin (11/7/2014)

---

MMartin1 (11/6/2014)

---

There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox....

There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox. It is a...

DonlSimpson (11/6/2014)

---

Actually, this is not correct. E.F. Codd introduced the concept of surrogate...

Using the wizard ...

Depending on the relationship of the tables, you can also then group the individual Data Flows (DFs) together into sequence containers and run those serially, with the...

chris.laxdal (11/5/2014)

---

Have you tried setting up the SQL Agent task to use 32-bit runtime? I have seen this many times where it fails to open the package if it...

Just a quick note here for anyone interested, surrogate keys are a data warehouse concept and not in the operational data system. Surrogate keys protect me (for instance) from the...

Is this still an ongoing issue. I wouldn't mind DDL statements with some sample data if so. Are the columns in your where clause properly indexed and statistics current? Could...

Jack Corbett (8/18/2014)

---

If you read the 1st link in my signature and post using those suggestions you'll get more and probably better answers because what you have posted...

The thing to keep in mind is why proxy accounts exist. When you schedule a package, the agent account (by default) on the machine you deployed to runs your IS...