This may be a config issue. Can you ask your admin to give you a copy of the config file so you can compare?

Its probably best to review all...

Thanks Jason - giving it a try this week! Seems crazy i can't just copy down the files but I'll take the automation either way.

Actually - the problem is not that they have both versions - they do not. However it seems SSRS 2008 is using the same constraints as Excel 2003. ...

Thanks Stephen - this worked like a charm!  I changed the extended property of the connection to convert the mixed to text.

Thanks for the suggestion Chuck. 

Unfortunately, the problem is not getting the data into the SQL table, it is getting it out of Excel.  SSIS is very flexible and allows...

Okay, here is one that bugs me and I hope someone has a more graceful solution!  How can I avoid writing, maintaining, and running dynamic queries when I want to...

PEBCAK!  User error here, please disregard!

Thanks to you both very much, worked like a charm!

Johnny,

Thanks for the link, unfortunately it doesn't help me as I've already placed and registered the component on the server.

Beth

I have also had this problem, I think it strted occurring with an upgrade of MDAC in Access 97. We dynamically linked our tables when the database opened by...

I have also had this problem, I think it strted occurring with an upgrade of MDAC in Access 97. We dynamically linked our tables when the database opened by...

Thanks for the quick response. Unfortunately the stored proc is already really long and kind of complex so I think I'll just create a different version for readibility and...

You are telling the SQL database that the parameter you are sending in is 400 characters. I'm not sure exactly how strings are passed between ADO and SQL, but...

John,

Thanks for the help, it worked like a charm once I showed the DBA how to register the components!

Beth

This makes a lot of sense! Then I don't need to implement the DTS interface, I think. I'll try this and let you know if it works.

Thanks,

Beth