Thanks, I will try that. I got a lot of responses to try the kerberos configuration tool for SQL as well.

k_t_Schmidt (2/12/2013)

---

bitbucket-25253 (8/22/2011)

---

Using OPENROWSET for example:

SELECT * FROM OPENROWSET('Microsoft.jet.OLEDB.4.0','Excel 8.0;DATABASE=c:\temp\items.xls;IMEX=1;HDR=No','SELECT * from

[items$1]')

Note the IMEX setting. If it is NOT present the open rowset reads the first 8...

bitbucket-25253 (8/22/2011)

---

Using OPENROWSET for example:

SELECT * FROM OPENROWSET('Microsoft.jet.OLEDB.4.0','Excel 8.0;DATABASE=c:\temp\items.xls;IMEX=1;HDR=No','SELECT * from

[items$1]')

Note the IMEX setting. If it is NOT present the open rowset reads the first 8 or...

So after weeks of agonizing pain of getting the error, "Invalid DLL or Export Type" when trying to use the "EditableRTF" option in the script task. Our deveolopers finally...

Does anyone know how to create an editable word doc from the CrystalDecisions.Shared DLL? I have tried the following but can't seem to get rid of the "Invalid DLL...

Have you experienced where the package takes a long time to run the report? I ran it from our in house application which does the same thing as the...

Is it possible to use integrated security with the connection properties?

Edit: YES it's possible..

myConnectionInfo.IntegratedSecurity = True

...

Perfect! Thanks. I still have some coding errors, but I think I will survive from this point. This has been very helpful!

ok, I totally didn't see the "check to make sure you are running the package in 32bit mode". How do I check this?

Chris Rutherford (1/24/2012)

---

Hey there,

Cheers for the reply. I do have one thing I'm stuck on though. I've Crystal Reports 2008 installed on my local machine so of course...

ummm...yah, that's a good idea. Thanks. 🙂

i'll take a shot at it and see what i can do.. Thanks so much for the suggestions.

fi we could get the process down to a couple of days I would be excited. 🙂

Sorry to be vague. The data goes into a table so we can do time punch calculations to see where there are violations. So we don't need all...

Real World Example: Wage and Hour Class Action Lawsuits. I am always working with dates on employment cases and many times the individual has many start and end dates....