Hello,
I have run into a little problem,
We have a Database Catalog named "Product-V1.0", and I need to create a DTS
package. However when I create the SQL connection and point to the Catalog,
it truncates the Catalog name to "Product-V1" removing the ".0" from the
name. Hence I can't connect. I tried to add [] around the Catalog name
without any effect. So firstly is there a way that I can configure the DTS
connection to work with this Catalog name. Alternately I was thinking that
perhaps I could create a Alias name for the Catalog and connect to this
name. I tried to create a linked Server, but creating the Linked server
produced the same result as the DTS and I could not connect.
If possible I would like to find an Alternate to renaming the Database
Catalog name.
Regards,
Bernard.Hi
You can not create an alias for a DB/catalog.
It is best to follow the standards as described in BOL "Using Identifiers".
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bernard Sircelj" wrote:
> Hello,
> I have run into a little problem,
> We have a Database Catalog named "Product-V1.0", and I need to create a DTS
> package. However when I create the SQL connection and point to the Catalog,
> it truncates the Catalog name to "Product-V1" removing the ".0" from the
> name. Hence I can't connect. I tried to add [] around the Catalog name
> without any effect. So firstly is there a way that I can configure the DTS
> connection to work with this Catalog name. Alternately I was thinking that
> perhaps I could create a Alias name for the Catalog and connect to this
> name. I tried to create a linked Server, but creating the Linked server
> produced the same result as the DTS and I could not connect.
> If possible I would like to find an Alternate to renaming the Database
> Catalog name.
> Regards,
> Bernard.
>
>
No comments:
Post a Comment