Thanks for the info.

thanks for the input. I will try.

Daniel

Thanks for your help.  But there is still an issue with it.  The data from the Excel spreadsheet was imported in from a different data source, and I am still...

Where\how do I add the 'IMEX=1' to the connection string in my SSIS package?  Do I go to properties on the Excel Source? 

Thanks for your  help.

Daniel

You can use the optional parameter when creating a stored procedure [ ; number ] . 

create proc usp_Test;4

As

Begin

Select * from sysobjects where type = 'u' order by name

End

You can...

Here you go:

select

Name, object_name(parent_obj), xtype

from

sysobjects where...

Thanks it worked but a little cumbersome.  I had to add the Sort Data Flow Tasks, but it worked.

Yes, thank you.  That was the problem. 

Daniel

I installed SQL Server 2005 Developer Edition.

On a machine that has SQL Server 2000 on it.

Thanks,

Daniel

SQLBill,

The folder doesn't have to exist when creating the dump device.  That is the way it has always worked and is working for the other client databases.  It is pretty...

Thank you for your help. I did try it, but it won't work for our solution. The actual XML doc that I am trying to build would have different...

I think it is a good article. It would be nice if you wrote a more thorough article comparing the two DB technologies. I don't have familiarity with DB2,...