Thanks, Jeff.

When I ran your SQL statement, I got this:

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'sys.Objects'.

Privileges, you think?

In my...

Thanks for responding.

I reposted on the SSIS forum.

We are converting SS2000 DTS packages to SSIS 2005.

I need help using a User Defined Function within a query on a table.

The function performs correctly.

select * from fn_Split('13.0,13.1,14.0,14.1' ,',')...

More info - In the Visual Studio 2005 BI Development Studio environment, there is a menu item SSIS\Package Configurations. This shows you where the config files are. There is a...

This same issue drove me insane a few weeks ago. Your package is probably using config files for the Connection Managers. I had to find the config files on my...