Thanks again But it did not prompted me to specify my instance name.

I dont have any default instance but I have only one named instance. Thats what I can...

Hello Sorry but did not work for me, here is what I got,

Adding 'domain\user' to the 'sysadmin' role on SQL Server instance 'SQLEXPRESS'.

Verify the 'MSSQL$SQLEXPRESS' service exists ...

[SC] EnumQueryServicesStatus:OpenService FAILED...

Thanks but for that you should be able to connect to SQL server using windows authentication too. And My question is I can not connect using windows authentication.

I already tried...

Thanks both for ur help.

I think I am feeling cool and happy with my logic because it generates random characters of same length that is provided in...

Thanks Thats much easier.

The example I created has email addresses length=8 but in reality it may be any length and I wanted to just replace as many characters...

Got it.

UPDATE test_43

SET email = REPLACE( email,REPLACE(SUBSTRING( email, 1, CHARINDEX( '@',email,1)), '@',''),LEFT(REPLACE(CAST(NEWID() AS VARCHAR(36)), '-', ''), LEN(REPLACE(SUBSTRING( email, 1, CHARINDEX( '@',email,1)), '@','')))) FROM test_43

Can not delete the question so posting...

Thanks a lot All. I ignored those errors and then ran the package/project deployment model and then modified connection strings and i hope that should do it. Cant run the...

Thanks I did that and

Visual studio conversion wizard popped up followed by SSIS Package Upgrade Wizard and I selected those packages and tried to upgrade but it failed to...

Okay Thanks a lot

Okay Craig, Thanks a lot. Please see below condition and the pieces I've created now I need to make them combined.

ii)in the case of Static plans

(1) if the hierarchy is...

That's sounds great. Thanks but I dont want CTE. Common table expression is there any other way? Thanks a ton

I didn’t hear anything back yet but I found something,

From this page, http://msdn.microsoft.com/en-us/library/ms189612.aspx

It says db_datawriter can DELETE, INSERT, UPDATE and

Db_ddladmin can use any DDL command. (CREATE< ALTER< DROP)

But only db_owner...

Got it.

the variable was missing. in READWRITEOnly = uVar_CurrentFileDateTime,uVar_latestFileName

In The Script Task, I tried the variables as

ReadOnlyVariables = uVar_CurrentFileName

ReadWriteVariables = uVar_latestFileName

But Still same error.

Is there any way to learn VB step by step or quick tutorial?

I did exactly what u said but no luck. If you get chance then can u please take a look at my package?