I was able to resolve issue.

Thanks.

OK, issue 1 is resolved i placed the file in the wrong location. I thought it was C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages when it actually was C:\Program Files\Microsoft SQL Server\100\DTS\Packages.

Any...

Evil Kraig F (2/19/2014)

---

You would do...

Evil Kraig F (2/19/2014)

---

elee1969 (2/19/2014)

---

Evil Kraig F (2/19/2014)

---

elee1969 (2/19/2014)

---

My first question is within the query it grabs data with a year date of 2015. Next july 1st the users would...

stormsentinelcammy (2/19/2014)

---

Use an execute sql task to grab the data the you need (i.e. from 2015 to 2016), then use a data flow task to take that data from that...

Evil Kraig F (2/19/2014)

---

elee1969 (2/19/2014)

---

My first question is within the query it grabs data with a year date of 2015. Next july 1st the users would need it to change...

Sean - I was able to figure it out. It was a stupid scrolling to fast and missed an option in privacy. I checked...

WendellB (1/22/2014)

---

What is the extension on the Access file? If it is .mde or .accde, then you have a compiled version that cannot be changed. Another less likely...

Thanks for all the help guys. I was able to get it back up last week. The sqlservr.exe file was corrupted. Could not start it from command line. So I...

Hi Gail - i actually saw your information earlier today. Thanks again. The only thing i...

sreekanth bandarla (1/3/2014)

---

Nothing more from Logs? The info provided doesn't look much useful to me for troubleshooting...Try investigating more Log entries(Both Windows App and SQL Error Logs) for clues.

Btw, what...

"The SQL Server (MSSQLSERVER) service failed to start due to the following error:

The service did not respond to the start or control request in a timely fashion."

MyDoggieJessie (8/28/2013)

---

I can't post the code from the office due to our proxy server not liking some of the keywords in the sql code, I can either email it to...

Sean Lange (8/22/2013)

---

If not too much time has elapsed you might still find it in the default trace.

In...

sdevanny (7/17/2013)

---

If you used my suggestion with a dervied column, you might want to double check and make sure that you have a correct count of delimiters and columns now....