kelvinthong83 (11/18/2010)

---

I have the same problem when importing data from an Excel file to a SQL 2005 database as well but my excel file stored in the SharePoint document library.

I've...

David Data (12/17/2010)

---

AIRWALKER, which version of SQL Server do you use? SQL Server 2008 SSIS supports both VB.NET and C#.NET, but earlier versions only supported VB.NET (or plain...

In the ScriptLanguage option I only have VB.Net, how can I add c#

thanks

Turns out the password in the configuration file was being wiped every time the package was executed. I just removed the configuration and setup a new one and it worked...

ok, found the cause of the problem...Thanks

thanks.

Just another quick question, my website has a few 100 users, when I switch over to sql server session state, will it have an affect on the users that are...

got this working by dropping the custome named database and re-runnung aspnet_regsql.exe with the following:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -S BPPAPPSDBVM -

E -ssadd -sstype p

now is working fine.

thanks for your assistance

thanks, I tried that but still having the same problem.

Thanks for you reply

cant see an article on the issue in the link you provided.

Hi, Im getting the same error, this is the connection string in my configuration file for my ssis package:

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

<ConfiguredValue>

Data Source=MYSERVER\;User ID=sa;Initial...

Thanks for your reply. Is it possible to do the same kind of camparing when the data is in the same tablle but in different rows?

Thanks for the replies guys, but I'm not seeing any clear easy to follow examples. I'm completly new to SSIS and I want to update our old dts packages...

Thanks

Greg, what can I say but THANKS ALOT, it worked perfectly.

Thanks again 😀