Drew,

I was multiplying by 100 in my original code.

Thanks.

dkatanski (12/28/2011)

---

I'll do that. Your advise was helpful, but I've been having trouble with the SQL permissions. I've found them, I've given myself permission, but still have had no...

You should consider posting your Microsoft Access issues to the Microsoft Access Forum.

It sounds like the following:

The Login that was used to link to the table does not have a User Account for the Database in which the table resides.

You can identify...

I bet those kangaroos come in handy when trying to navigate through storms.

Merry Christmas, Ho Ho Ho! 🙂

lkokeunda (12/24/2011)

---

The upgrade path is not a bad deal. I prefer that route but to each their own.

Do you by chance mean that upgrade exams are cheaper than version...

ok, start studying now but why not go for the 2008 Certification?

The upgrade path is not a bad deal. I prefer that route but to each their own.

An opinion is...

lkokeunda (12/24/2011)

---

My 2 cents would be that I would search around on YouTube for SQL Server 2008 administration training videos. You may have to do some searching, but you...

Thanks for the feedback.:-)

When I first used the script task in my first Package to assign a value to a variable I thought that the code was not updating the...

Burninator (12/23/2011)

---

I think it's jsut the way that Excel handles a variance in data type within a column. your first few rows make Excel think you have a text...

I upgraded from 2005 to 2008 so I only had to take the 2005 equivalent but as was suggested you will need as much hands on as you can get...

ZZartin (12/23/2011)

---

Yep I believe you can create a variable in the package and set EvaluateAsExpression to True and set the expression for that variable to the file path, then use...

When I create the file I use an Expression in the Connection String Property.

How do I save the expression to a variable when creating the file and use that variable...

No ideas or hints?:crying: