Search results

Thanks I did that, that is how I got it working here it is: "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /file C:\Temp\sheet2_loader.dtsx

Trying to call a SSIS loader to fill some tables. If I use XP I can go to "Start", "Run", and place the loader's name and path, it runs fine, When I try to call this same thing via a MS access macro with RunApp I get the error: "Microsoft Access can't invoke the application using the Run App...

Changed data types, refreshed SQL DB, refreshed Access link.... Same issue.

Bob Larson, What is the correct default value? What is it for nvarchar? ( I am using the SQL server driver in the ODBC connection list ) Thanks for the information.

I have an Access Front End, A SQL Server 2005 backend. I have one table (Main) one field set to "nchar(12) ", ("default vale is set to "0" ). I link via an ODBC driver. When I go to the field and try to enter "123456789012" It stops me anywhere from the first character to the six character and...