Have you tried executing it in 32-bit mode?

Link here.

SQL!$@w$0ME (4/22/2016)

---

Yes Phil, Using Windows authentication. Also as part of the package a report file(excel) is created on the shared folder. All other packages runs fine when executed from remote...

Phil Parkin (4/22/2016)

---

DuncEduardo (4/22/2016)

---

So if you read again my first post I detail exactly what happens when I try to upgrade. This is what I'm trying to resolve, and hoping...

DuncEduardo (4/22/2016)

---

So if you read again my first post I detail exactly what happens when I try to upgrade. This is what I'm trying to resolve, and hoping to get...

No, the upgrade process should be as simple...

OK, understood. But don't forget that tables in SQL Server are pretty good at storing info like that 😀

Do you connect to the SQL instance using Windows Authentication?

alicesql (4/22/2016)

---

Thanks, Phil.

[Acct Year] is determined in the T-SQL stored procedure that runs and loads the table being extracted. So that data coming in when this runs today has either...

DuncEduardo (4/22/2016)

---

Hi Phil,

Thanks for info but I'll try to just elaborate on my specific issue.

I deploy from Visual Studio Integrated Shell 2012 to server running SSMS 2014.

My configuration is -...

What concerns me a little about your approach is that you seem to be deriving information about your source data based on the date/time the job runs.

Would it not be...

SQL!$@w$0ME (4/22/2016)

---

We are using project deployment model for SSIS. For one of the packages, which writes the log to a UNC path, I get the error when running the package...

jonathanmarenus (4/22/2016)

---

I have an SSIS package that appears to be stopping after a ForEach Loop container. The container passes in an ID returned from a query. When no...

The walking freezer is what I want to see.

Technique #2: Make your query readable by using indentation and code="sql" tags:

SELECT DISTINCT

Systems.SiteNumber AS 'SiteNumber'

, ...

mbavabohrude (4/22/2016)

---

I Need help in optimizing the query ,

Could you please throw some techniques or any valid query for replacement of this query . Help is highly appreciated as i...

j-1064772 (4/21/2016)

---

The C# bit I got from a colleague at the office who has considerably more experience than I do.

He was referring to the specific cases a dictionary structure so...