Help with Connections

Hi everybody,

I need a little help...

I created several packages, that after their creation should not be changed again; that's why I created a Package Configuration File in which I set all the Connections I need, so that this is the only file I have to modify.

I set there also the path of the connections for my log file and for my error files (which are both text files), but if I change their paths in the configuration file this change doesn't affect the package, and the path of the log remains the same.

That's an image of one of those packages....

The fact is that I cannot change the ConnectionString of the connection called "log_pkg", but it always remains the same...

How can I resolve this problem?

Thanks everyone

In general this should work. I just did a quick test where I had a package already which contained a Text Log Provider so I added an XML type configuration to the package, on just the connetion string. If I edit the config file and change the name of the file, rerun the package the, the new name is created.

this was section of the config file I was editing, specifically the name in the string "ftp_Log2.txt"

- <Configuration ConfiguredType="Property" Path="\Package.Connections[ftp_Log.txt].Properties[ConnectionString]" ValueType="String">

<ConfiguredValue>C:\_work\SSISPackages\ProtectionLevelTest\ftp_Log2.txt</ConfiguredValue>

</Configuration>

You are doing something similar and it does not work?

When you execute in BI studio, do you see a message similar to the followingin the output window indicating the config file was read?

Information: 0x40016041 at ftptesting: The package is attempting to configure from the XML file "C:\SSISPackages\ftpconfig.dtsConfig".

Help with accessing database

Hello,

I just switched to a host that allows database connections so that I can now upload my database to their server.

When I test my site on my personal PC it works great. I upload everything to the server and nothing. I know that I need to load the database to the server. I have Microsoft SQL Server 2005 Express and can make the connection but how do i load my database from my personal PC to the host computer?

I would be greatful if someone was able to walk me thou the steps on how to transfer the database. I am really very new with the database thing and ASP.

Thank You

Chris

this Embedded database feature is only available in SQL SErver express. In all other edition of the sql server 2005 , this featuer will not work. If you need to transfer the database from you r pc to host , if its not Express then you need to either use Backup/restore method or Dettach/attach method to transfer the database. And also you need to change the connection string since its totally differ.

You can refer BOL for Backup /Restore database with Move option and also Sp_Attach_db and sp_detach_db

Madhu

Help with "How to configure SQL Server 2005 to allow remote connections"

Hi there! I've been trying for several days now to configure SQL Server 2005 to allow remote connections, apparently, with no luck.

I always have this error message: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

I've followed the instructions at this link ->http://support.microsoft.com/?kbid=914277&SD=tech, but I have been having the same problems.

I've already adjusted my firewall settings.

What should I do?

Please help me...

Hi,

Make sure that the servername, username and password are correctly configured in your config file. Try checking that by accessing the DB locally on the server itself.

HTH,

Vivek

|||

Make sure your connectionstring is correcthere and TCP/IP and named pipes is enabled check this:SQL Server Troubleshooting .

Hoep it helps.