Comments by ranio (Top 76 by date)

I meant to check DueMonth node value in the Xml (say 202102) if exists I need to take that value alone without looping

_tempDate = _tempDate.AddMonths(1);

//Added by Alex on 12.5.2021 to fetch New Bill Date with Holiday Configuration for Loan Postponement Issue Start
string a = _tempDate.ToString("yyyy/MM/dd hh:mm:ss tt");
DateTime dtNew = DateTime.ParseExact(a, "yyyy/MM/dd hh:mm:ss tt", System.Globalization.CultureInfo.InvariantCulture);
on checking string a I am getting date format in yyyy/mm/dd hh:mm:ss tt
But on converting to datetime it is getting changed to dd/mm/yyyy hh:mm:ss tt
How to keep the format as it is

first issue is gone. but in the second one i am getting out of index range issue on assigning
I added as below:
List<detail> Details = new List<detail>
{
new Detail {ROLEID = "12345"}

};

//obj.Details.Add("123");
//obj.Details[0].ROLEID = "abc";

objGetRoleDetailsResponse.Details[0].ROLEID = Details[0].ROLEID.ToString(); //at this point getting i am getting out of index range issue on assigning
i am returning this class object

response is coming fine for me but only after a delay as mentioned in my query. so are you telling setting request.proxy as you told will reduce the response delay.

There is no password tag in the request API . From the password digest value i need to get the Password text back on consuming the Request API sample as mentioned above and authenticate .

I tried some options. But what is happening is that i am getting multiple cookie paths.
I just want the second one and remove the default / path
One mapped to root path as /
Another mapped to the virtual directory /test

My code:
Web.Config file
<add key="UserDefiniedCookiePathFilter" value="/DDS_AHB">

Global.asax page
Under Application_PreSendRequestHeaders Event

string CookiePath= ConfigurationManager.AppSettings["UserDefiniedCookiePathFilter"];
Response.AppendHeader("Set-Cookie", "path="+CookiePath);

Above link is being shown simply as a static progress bar column with percentage but not in a dynamic way.

I am getting the exception "Object reference not set to an instance of an object" and it is happening at the code line
var sites = iisManager.Sites["Default Web Site"];

what about using innerText instead of innerHtml
document.getElementById('ctl00_cphDDS_lblSelectedOriginator').innerText = dialogWindow.CompanyName;

data is set client side and passed to pop up screen page from there. The issue is the datas are being able to manipulated as per the issue mentioned. Is there any way to avoid data changing other than the option to handle server side especially with many pages dependent on it already.

data is set client side and passed to pop up screen page from there. The issue is the datas are being able to manipulated as per the issue mentioned. Is there any way to avoid data changing other than the option to handle server side especially with many pages dependent on it already.

sql server 2008

we are using IE Browser. window.name won't work naa.

what i need is to select all checkbox on clicking checkbox header and update. Also i need to maintain the checkbox checked while navigating to another page with in the grid.

Th length of the bytes are 16 but while converting the bytes to base64 string the length varies for AES Key generated with 128 bit. It becomes greater than 64. The AES Key string length for 128 bit must be always 16.

How to update the existing xml using xdoc. I mean the objCBAPIDetails.requestAPI

I passed the encrypted request data and encrypted request key data in asp.net with c#. But while decrypting a json string I am getting as below: There are characters like \u003e,\u003c which is to coming for xml characters

Client:{"webServiceResponse":{"responseDetails":{"encrypyedResponseKeyData":"MyKey","encryptedResponseData":"\u003cwebServiceInputDetails\u003e\r\n    \u003centityDetails\u003e\r\n        \u003cbankId\u003e011\u003c/bankId\u003e\r\n        \u003cpassword\u003e011\u003c/password\u003e\r\n        \u003csignature\u003e\u003c/signature \u003e\r\n        \u003cuserName\u003e011\u003c/userName\u003e\r\n    \u003c/entityDetails\u003e\r\n    \u003cwsData\u003e\r\n        \u003csendingInstutionRef\u003etest\u003c/sendingInstutionRef\u003e\r\n        \u003corderingCustomerAccount\u003etest\u003c/orderingCustomerAccount\u003etest\r\n        \u003corderingCustomerName\u003etest\u003c/orderingCustomerName\u003e\r\n        \u003cbeneficiaryAccount\u003eAE890100000112028030820\u003c/beneficiaryAccount\u003etest\r\n        \u003cbeneficiaryAccountName\u003etest1\u003c/beneficiaryAccountName\u003etest\r\n        \u003cbeneficiaryAccountAddress\u003etest\u003c/beneficiaryAccountAddress\u003etest\r\n        \u003corderingCustomerAddress\u003etest\u003c/orderingCustomerAddress \u003e\r\n        \u003cinstructedAmount\u003etest\u003c/instructedAmount\u003e\r\n        \u003cremittanceInfo\u003etest\u003c/remittanceInfo\u003e\r\n        \u003cpurposeOfPayment\u003etest\u003c/purposeOfPayment\u003e\r\n    \u003c/wsData\u003e\r\n\u003c/webServiceInputDetails\u003e"}}}

I tried to get the encrypyedRequestKeyData and encryptedRequestData json string as below:

But getting object reference issue.
string jsonString = objApi.ReqAPI;
var details = JObject.Parse(jsonString);

objApi.encryptedRequestKeyData = details["encrypyedRequestKeyData"].ToString();
objApi.encryptedRequestData = details["encryptedRequestData"].ToString();


My json string is as below:
{"webServiceRequest":{"entityDetails":{"entityId":"123","userName":"TEST","password":"TEST123","serviceId":"12344321","requesterWsiRef":"WSI592944205332743307"},"requestDetails":{"encrypyedRequestKeyData":"fye1gPxpyejR35ziHJyAAQ==","encryptedRequestData":"kzIfErBjhTiZL+9O19aD/Wfo2ezC2jeTEB/WAGZ/8VyDPNpxlyzwUdQWauFk1/bvIVhgw57nm1xhGgfUhk7O+YpiJnBzUVAaPvjwF7NXciKx+ys+niBsHwli37K2ZDUkh0Vv4sHpUaEW1fEvuB+v+FQWNDwNvvWasQQKzQLSLzVgFAiKSQ07tu4OjXt9i0/cArrshEMGKZnutN9XgKmCD+xNVqdXhOWhDFE0SBew6AKcp4jf2dgcBlJ8yTCcQMO1qYqijC/2KmTDV0cwNjqH1/DEDCMLiQPYP8eBg/PVjcZJQ8k0Wfzr6W05AH0hPnSaAF0dHbbD0Es2Iktaq0jgtP9nLpSna0n9lv1Fa9CjnSeaIf+GXVI1Zd1gMXdttzQQUVMv5MZDnXyeAe8+1wIZipiX52jRdHdXnJSHCSVEvi7IjyM14etN0tfGF6HYHas9G2tcromwJCYJfKC20bjQWke9vFFZ4BdwIIv72FWpfXhk4WQLJviFXJ4b9xaadsPELKPL+tMTuGMXSl8SNBKWyYjOv0b5zVsvKirRNMc24RIoMkLSV86jePfh5bXhgXkXFChQvbIYPISd/yFxOFPoZvsIA8Zq9x3uYxw4V3BmSjfJKToIIH2qenbKyJjs9yA4LY8uG23zXfSDzGReM5pmZTMJdmpqY5RKd77+TKr1sB3neR0qUG//V1BU1Ljk6Y4dvQUxnquWNAlJCXVsHRsGipvNzqiMP4ZESMoLt3w/P4Txbqz46wvgCgICHrh6kxikV6ubynv1MMavhnE7plq3cI2Tmh/XgO7+fYFwRcKZ/SUBWXprBIqdGyyqGK49ics8++IXocFZ2IGJe4OhklsRJabX0L0S3sP9/VCQZiMseS/THeF5jtScQWwNixSwsmC0QchTS83fHmiJ7mfvF2W9c1hremX0g8J5YG1nwxBXtQUz8gTuul1+1eiiJ1v8RHMAYBAUslE17H1YZeNJa4SVrtYxHCG3YtbdT/ZRYJ5aVcJH3EmqJ/HoQ3smqaxNUpO3Yd8ESboAL5uOa5Zn5XoKaU9P3R1tshYX4gC40w4R1UGBkdhuIfCYqv6dcOsDpLOIcoxMqhthz9Cge4W5faMELuWp5+e19qYZzGwVPEDnQ1d5JL4xbMmsMCkzbruTT1Hm7gBumju9L/pq9qEzu3aFaXlgaWwYxd+4V/ly9rI/GEFJb0rAZVjyRsaiPyPqIuzZiD/UWUT99+rBNtnwi9Qq2R7JrcNCAs/rn4dbqwDfTSFgLNnPzY6x7aVbCOf4rnfu2wRyiVL+9ElxPMm9Kc7sgNrHUcCizqCwDt0eW4KaA9vDsFmmLWpX+0bLXJRI3PRDvYQdzGkrsdgGbpC1wv/BiyO6DblfFdKwMDWMwhxhglSEp+nw4W9QanuChRa+Jn6aYIz91sAL0VfcquEFQVfVYfAwuPhIEtC2cqBPs6aahUEq4+3p6kvenzkKlXHA4QRVpnk/b/6IdqQCoUoPaccM1VUzGzUALYKf4dl+CGlId6bXqphUB33tQiSelAhMbeE+pRbJvu7+4kMj5D6Dkbn4jd4R7fhwMVJA+0/nzDShiRoylt6hI4dDOj1ySwvjE4uBk1B4IaAges0nnKlZXTtZKk1QXKj9I47bjLtkpzjweHx9HsJ6f4Ci8O3wRMCwCt7qRzLMQv/3hvmUrYZRgG227KhBt5UyPqs1KN3kP7W/xnNkwLKxowVMXERIVwupLcx1SxEGRolxV2LPd96ItovOw09/ADjKwD9jNMDt512nYdXsnGvTQogJwFOC0RsgAas4QhdrC79R+FZeUn0uWnFa9eKTvRaAwBYabivqi7tAA8r5gI7Xby4rjwaZVM5+flOfY7Z60pXu6PNvi/IgXzV257hRi9Zqb8TWjWgDORyVkbOKOeAoK3miXbeWiqAW6RNWbv+YX4bLMxWm9Jr9I0PwUpISIaBbsdng/mG42Ea3+qvuzgIYXDJLqDP2ZSPDeDSfJV2vslB1Iy/7jveFrF9UhmbN4GpnGyx7VDituACbxvsxzrIdNjBHHEyKXsEH00I8SydKUm51NNBBzVGfaUmPzXtRAgkdLR57NEBMoEWVF3FMS8MZz0WyA2nblwzfGwKkwE7XNiB81bGMc89SeKgv313A6xTFXkUy+0QwL1q67eecMrVI9vRzxntry36TGAlcRHlTLDg6fuNbyjVrM4rDoiecaUeH4jOBYfiTI9tIujl1FMZdHdf0YXC7sGl0SDEAXAMDN0zjlNRHUbUM+tf6CN5pewkFtotkBKTHp1SwoPTtq+1OSB3sEtgf3NZTTFKqqhky+o3Grxv/zU94JjqdAs6MC1UPhFp6Fl01Bj6tmy4="}}}

Another option to resolve the same was done as below:
but the websocketresult.EndofMessage() is coming as false. I passed simple string "test" and hence getting looped with in it repeatedly.
ArraySegment<byte> buffer = new ArraySegment<byte>(new Byte[8192]);

WebSocketReceiveResult result = null;

using (var ms = new MemoryStream())
{
do
{
result = await webSocket.ReceiveAsync(buffer, CancellationToken.None);



ms.Write(buffer.Array, buffer.Offset, result.Count);
}

while (!result.EndOfMessage) ;

ms.Seek(0, SeekOrigin.Begin);

if (result.MessageType == WebSocketMessageType.Text)
{
using (var reader = new StreamReader(ms, Encoding.UTF8))
{
// reader.ReadToEnd();
txtOutgoing.Text = reader.ReadToEnd();
}
}

Please see the entire core code to send and receive using web socket as shown below: Updated in the Post too . Awaiting a solution asap.

Core Code as below:
Client lEVEL:

 #region Send        private async Task Send(ClientWebSocket webSocket)        {            try            {                NeSTCommonClass.WriteTextFile(LogPath + Logfilename, "Client:Sending to Server Process Begins", true);                // while (webSocket.State == WebSocketState.Open)                if (webSocket.State == WebSocketState.Open)                    {                    //Console.WriteLine("Write some to send over to server..");                    //string stringtoSend = Console.ReadLine();                    string stringtoSend = txtOutgoing.Text;                    byte[] buffer = encoding.GetBytes(stringtoSend);                    await webSocket.SendAsync(new ArraySegment<byte>(buffer), WebSocketMessageType.Binary, false, CancellationToken.None);                    // Console.WriteLine("Sent:     " + stringtoSend);                                      await Task.Delay(1000);                }            }            catch (Exception ex)            {                NeSTCommonClass.WriteTextFile(LogPath + Logfilename, "Client:Sending to Server Process Failed: " + ex.Message.ToString() + "", true);            }            NeSTCommonClass.WriteTextFile(LogPath + Logfilename, "Client:Sending to Server Process Ends", true);        }        #endregion

Server Level:
processing received data from Client is as below:
Processing the client level request from server as below;

 byte[] receiveBuffer = new byte[1024 * 10];                WebSocketReceiveResult receiveResult = await webSocket.ReceiveAsync(new ArraySegment<byte>(receiveBuffer), CancellationToken.None);                    var ServerstrReceived = System.Text.Encoding.Default.GetString(receiveBuffer);                    txtIncoming.Text += Environment.NewLine + "Client:" + ServerstrReceived.ToString();                    //Added to send to Client from Server                    //string stringtoSend = txtOutgoing.Text;                    //byte[] buffer = encoding.GetBytes(stringtoSend);                    //await webSocket.SendAsync(new ArraySegment<byte>(buffer), WebSocketMessageType.Binary, false, CancellationToken.None);                    //Added to send to Client                    if (receiveResult.MessageType == WebSocketMessageType.Close)                        await webSocket.CloseAsync(WebSocketCloseStatus.NormalClosure, "", CancellationToken.None);                  

The solution is run in the same instance. It is set with Server call first and Client Call second in the application start up properties.

I get the exception as below:
Only Uri prefixes ending in '/' are allowed.
Parameter name: uriPrefix'

I need to make a handshake request using web socket in asp.net. But how could i send the
same:
How could I make the HANDSHAKE request to the following URI:
(“wss://10.1.1.1/CBWSO/wso ?test=1&ade=2

What i meant whether it is possible to pass the web socket url with query string. I am doing it in in framework 4.6

Tried below way:

using (var ws = new WebSocket("ws://dragonsnest.far/Laputa"))
{
ws.connect();
}
such code line not supporting either. i am having a wcf service and want to set communication over the web socket in c#.
any solution there to do the same. without query string no issue.

I am able to pass values concatenated fine for the first one. But second one getting invalid json delimiter




First one fine
string jsonstr = @"{""bankId"": 049, ""password"": ""P049563445634674574325323674we5476956789057905694565745764256456"", ""userName"":""6919301721649254400252100878956720265267481307739303873300957305"",""timestamp"":""10:00:00""}";

Output of first one which is fine:

{
"bankId": 1,
"password": "foo",
"signature": "",
"userName": "bar"
}

HandShakeRequest resultT = new JavaScriptSerializer().Deserialize<handshakerequest>(jsonstr);



Second one getting invalid json delimiter
string jsonstr2 = @"{'bankId':" + bankid + ",'password': " + password + ",'userName': " + userName + "}";

Output:
{
'bankId': 1,
'password': "foo",
'signature': "",
'userName': "bar"
}

Output of the second one which is getting issue as invalid json delimiter
string jsonstr2 = @"{'bankId':" + bankid + ",'password': " + password + ",'userName': " + userName + "}";

HandShakeRequest resultT = new JavaScriptSerializer().Deserialize<handshakerequest>(jsonstr);

I want to fetch the columns from table as in below format

I mean say

insert into test([a].[b],[c])
select [a],[b],[c] from abc

all columns must be with in square braces as mentioned above.
i need to set so in the dynamic script shown below:

select @SourceColumnList = @SourceColumnList + ',' + case when DATA_TYPE = 'xml' then 'convert(varchar(max),'+column_name+')' else column_name end
from information_schema.columns
where table_name = @TableName and DATA_TYPE not in ('timestamp')

select @DestinationColumnList= @DestinationColumnList+ ',' + column_name
from information_schema.columns
where table_name = @TableName and DATA_TYPE not in ('timestamp')


set @SourceColumnList= RIGHT(@SourceColumnList,Len(@SourceColumnList)-1)
set @DestinationColumnList= RIGHT(@DestinationColumnList,Len(@DestinationColumnList)-1)

The column is there but the issue was not becoz setting the column list with square braces while fetching the columns of a table dynamically as below.
core code is as below:
select @SourceColumnList = @SourceColumnList + ',' + case when DATA_TYPE = 'xml' then 'convert(varchar(max),'+column_name+')' else column_name end
from information_schema.columns
where table_name = @TableName and DATA_TYPE not in ('timestamp')

select @DestinationColumnList= '[' + @DestinationColumnList+ ']'+ ',' + column_name
from information_schema.columns
where table_name = @TableName and DATA_TYPE not in ('timestamp')

select @SourceColumnList

select @DestinationColumnList

set @SourceColumnList= RIGHT(@SourceColumnList,Len(@SourceColumnList)-1)
set @DestinationColumnList= RIGHT(@DestinationColumnList,Len(@DestinationColumnList)-1)

Below is the Content:
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v2.0.22 (MingW32)

mQENBFodV6IBCADbWOiM9wd1v023MSuJhqPrbcJzkBewR6umUOujo+X5mA4E4YUs
o7OzwHjsF4CA5e7/eOuooIwcJ/zCthbkUBEszi1o991eD4zTLM2jKUXKMPmvlLqs
zdISDxBJSWNnaz6taW55NPYL+BMS7Be9/wuChMY5p8HS3SQXBFjWqtZ6SkHL33Gk
QtQVjZD8eh3OJ+tXXP5cv6taUgrTsxzzI2F+j8+jwu+0guU66o1d3Q8IoH4C8yCH
xu2szuZmzQst19MF64Z5w7DGl0Y1KEbL0sgxvQ0Wmoxcqycit+78eeq5590/6l5R
7+ScP/koDeACBdaq/UJspGc3nnMfZwRQTNgZABEBAAG0IENCX1dTSSA8bmFuZGh1
LnBrQG5lc3Rncm91cC5uZXQ+iQE5BBMBAgAjBQJaHVeiAhsPBwsJCAcDAgEGFQgC
CQoLBBYCAwECHgECF4AACgkQ0/gIj6+qv9537ggAwkQ35yRYkCxJ3AdnEMxfCLpn
1Z8/yUSiawc4t81mIGD1WPDJDVbnPApI8fhqrHxHWyFgA/6U7z62wWV71UC2Ww81
NYWJGvLDkrgth7TdGd9ngBy447AgzsmcaJ4a/GAsFNgWnyRMhzaCs1Hmz51tjlSY
5txuMBO8avIBPQ5E4ULz9pAWjkQ72le+dXJSY7b1qNxkIvwk0GNkk/Uvi4YdQ9Lf
pRUXaua8VBnXzXuqY+rcA5n2d4PZDBRldgEoRwEqAciU4wonxFIKY7jdfnCLWWtf
+92Nxd41tsn3nj6eBnKcE6+2HNcCV9lxn879hWMD+34el7IuCMM8JIyyshp3mg==
=6CSY
-----END PGP PUBLIC KEY BLOCK-----

So what is the solution for saving public key content length greater than 512 bytes long. Can I split the same say 500 bytes each and then save to the vault and retrieve concatenating the splited vault values altogether.

Is this split option possible or Is there any better option to do the same ?

Async call is needed as there are multiple threads running in the service already set. Client side was set to asp.net page itself. Console commands used are those used as part of the console application. But I need to use as a web application to set it in the asp.net page code . I am getting the response message but unable to pass that variable outside since the scope of it is limited in the call back handler class.

Client Side:
var context = new InstanceContext(new WCFServiceCallbackHandler());
var client = new ServiceReference1.Service1Client(context);



bool exit = false;
Console.WriteLine("Enter X to exit:");
Console.WriteLine("Write and enter to send something to server:");


while (!exit)
{
Console.WriteLine("Client:");

String stringToSend = txtMsgToServer.Text;
if (stringToSend.ToUpper() != "X")
{
client.Hello(stringToSend);
}
else { exit = true; }

}





}


WCF Call back Handler to invoke WCF Service server side:
public class WCFServiceCallbackHandler : ServiceReference1.IService1Callback
{
public string result { get; set; }

void ServiceReference1.IService1Callback.OnHello(string message)
{
Console.WriteLine(message);
result = message;

//HttpContext context = HttpContext.Current;
//context.Session["message"] = message;

}

}

What is the Password length limit while saving in Windows vault folder using c#?

I am able to save the credentials in the windows vault folder, but I can see the same and edit by going to Control Panel->User Accounts->Credential Manager. i need to keep it secured

csv injection attack or so was told. For that special characters are mentioned as above and i need to block if there without reading line by line which cause performance issue.

What i need is to validate special characters like +, =, "", @ exists in the bulk files(excel/csv). Not related to Sql.

the exception I got is the process cannot access the file because it is already being used by another process in the error log. The code for the same done are as below:

public bool CopyFolderContents(string SourcePath, string DestinationPath,int ArchivalAge)
{

Archive AC = new Archive();
try
{

string ServiceLogFileName = System.Configuration.ConfigurationSettings.AppSettings["ServiceLogPath"].ToString() + "SERVICE_LOG_" + DateTime.Now.ToString("yyyy-MM-dd") + ".txt";
AC.WriteTextFile(ServiceLogFileName, "Inside CopyFolderContents():" + DateTime.Now.ToString() + Environment.NewLine);

SourcePath = SourcePath.EndsWith(@"\") ? SourcePath : SourcePath + @"\";
DestinationPath = DestinationPath.EndsWith(@"\") ? DestinationPath : DestinationPath + @"\";

if (Directory.Exists(SourcePath))
{
if (Directory.Exists(DestinationPath) == false)
{
Directory.CreateDirectory(DestinationPath);
}

foreach (string file in Directory.GetFiles(SourcePath))
{
DateTime FromDateTime = DateTime.Now.AddDays(ArchivalAge);
//DateTime FromDate = Convert.ToDateTime(FromDateTime.ToString("yyyy/MM/dd"));
DateTime dtFileCreatedDate = File.GetCreationTime(file);

if (dtFileCreatedDate.Date <= FromDateTime.Date)
{
FileInfo fileInfo = new FileInfo(file);

//fileInfo.CopyTo(string.Format(@"{0}\{1}", DestinationPath, fileInfo.Name), true);

string SourceFilePath = file;
string DestinationFilePath = DestinationPath + Path.GetFileName(file);


if (!File.Exists(DestinationFilePath))
{
File.Move(SourceFilePath, DestinationFilePath);
//FileCount = FileCount + 1;
}

}
}

foreach (string drs in Directory.GetDirectories(SourcePath))
{
DirectoryInfo directoryInfo = new DirectoryInfo(drs);
if (CopyFolderContents(drs, DestinationPath + directoryInfo.Name,ArchivalAge) == false)
{
return false;
}
}
}
return true;
}
catch (Exception ex)
{

string ErrorLogFileName = System.Configuration.ConfigurationSettings.AppSettings["ErrorLogPath"].ToString() + "SERVICE_LOG_" + DateTime.Now.ToString("yyyy-MM-dd") + ".txt";
AC.WriteTextFile(ErrorLogFileName, "Inside File Archival- CopyFolderContents():" + DateTime.Now.ToString() + Environment.NewLine);
return false;
}
}

Is there any other solution to reduce the slowness without converting the menu to user control as the time frame is less.

Solution obtained. It was a path related issue which was rectified and now fine in hosted machine too. Same code worked.

I have updated the code portion for your better understanding. Locally with the same code updated it is fine. Issue seen after hosting

Awaiting a response upon this ASAP.

The result is still coming as empty string value after package execution code

I tried the above method but cannot use as the configuration child node is there multiple times. i want to get the ConnectionString part with in a Configuration Child node in the XML Structure. I need to avoid the foreach loop currently being used.
Xml is as below:
<?xml version="1.0"?>

<dtsconfiguration>


<dtsconfigurationheading>

<DTSConfigurationFileInfo GeneratedDate="06/04/2018 11:06:33" GeneratedFromPackageID="{5A776659-3F33-4F34-A91A-D4BC80548271}" GeneratedFromPackageName="Package" GeneratedBy="CHN\Hasna.EK"/>




<Configuration ValueType="Boolean" Path="\Package.Connections[Flat File Connection Manager].Properties[AlwaysCheckForRowDelimiters]" ConfiguredType="Property">

<configuredvalue>-1




-<Configuration ValueType="Int32" Path="\Package.Connections[Flat File Connection Manager].Properties[CodePage]" ConfiguredType="Property">

<configuredvalue>1252




-<Configuration ValueType="Boolean" Path="\Package.Connections[Flat File Connection Manager].Properties[ColumnNamesInFirstDataRow]" ConfiguredType="Property">

<configuredvalue>-1




-<Configuration ValueType="String" Path="\Package.Connections[Flat File Connection Manager].Properties[ConnectionString]" ConfiguredType="Property">

<configuredvalue>E:\SSIS\Test3\emp.txt



</DTSConfiguration




doc.SelectSingleNode("/DTSConfiguration/DTSConfigurationheading/Configuration").InnerText = "test";

I have set a source destination mapping in SSIS. I am setting source to a flat file component(text file contents) read and mapped to Sql DB and insertion is being done accordingly. I want to change the flat file Source connection string alone dynamically and save to destination mapped. Set flat file Source connection string is not getting updated.

Mapped Source Path Connection String:
string strSourceConn = @"D:\SSIS\Test3\empdetails.txt";

Source path Connection String:

string strSourceConn = @"D:\SSIS\Test3\emp.txt";
// Create a new SSIS Package

//Package package;
Microsoft.SqlServer.Dts.Runtime.Application app;

string pkgLocation = @"D:\SSIS\Test3\Integration Services Project2\Integration Services Project2\Package.dtsx";

app = new Microsoft.SqlServer.Dts.Runtime.Application();
package = app.LoadPackage(pkgLocation, null);
// Add a Connection Manager to the Package, of type, FLATFILE
var connMgrFlatFile = package.Connections.Add("FLATFILE");

connMgrFlatFile.ConnectionString = strSourceConn;
connMgrFlatFile.Name = "My Import File Connection";
connMgrFlatFile.Description = "Flat File Connection";

package.Execute();

I am able to map the source and destination to a table in Sql Server in a package. But i need to change the source path dynamically . While invoking the package path set manually is getting worked instead of the source path dynamically.

Core code is as below

try
{

Application app = new Application();



Package package = null;

package = app.LoadPackage(@"D:\SSIS\Test3\Integration Services Project1\Integration Services Project1\Package.dtsx", null);

// Add a Connection Manager to the Package, of type, FLATFILE
var file = @"D:\SSIS\Test3\employee11.txt";//Source Path set
var connMgrFlatFile = package.Connections.Add("FLATFILE");

connMgrFlatFile.ConnectionString = file;
connMgrFlatFile.Name = "My Import File Connection";
connMgrFlatFile.Description = "Flat File Connection";


// Configure Columns and their Properties for the Flat File Connection Manager
var connMgrFlatFileInnerObj = (Wrapper.IDTSConnectionManagerFlatFile100)connMgrFlatFile.InnerObject;

connMgrFlatFileInnerObj.RowDelimiter = "\r\n";
connMgrFlatFileInnerObj.ColumnNamesInFirstDataRow = false;



//Excute Package

Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();



if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)
{

foreach (Microsoft.SqlServer.Dts.Runtime.DtsError local_DtsError in package.Errors)
{



Console.WriteLine("Package Execution results: {0}", local_DtsError.Description.ToString());

Console.WriteLine();

}

}

Response.Write("alert('Saved Successfully')");

}

catch (DtsException ex)
{

// Exception = ex.Message;

}
}

That is possible. Will try with few sample files and see and update.
As mentioned would simply iterate the files in the sub folder of parent folder and apply for each loop and pass the files as in the code done by me
string strSourceConn = @"C:\Users\employee.txt";
string strDestConn = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();

string pkgLocation = @"D:\SSIS\Test\Integration Services Project1\Integration Services Project1\Package.dtsx";


Package pkg;
Microsoft.SqlServer.Dts.Runtime.Application app;
DTSExecResult pkgResults;

app = new Microsoft.SqlServer.Dts.Runtime.Application();
pkg = app.LoadPackage(pkgLocation, null);

//pkg.Variables["strSourceFile"].Value = strSourceConn;
//pkg.Variables["DestinationFilePath"].Value = strDestConn;

// pkgResults = pkg.Execute();
Variables vars;
vars = pkg.Variables;
vars["strSourceFile"].Value = strSourceConn;
vars["DestinationFilePath"].Value = strDestConn;
pkgResults = pkg.Execute(null, vars, null, null, null);
//Response.Write(pkg.ExecutionResult);
Response.Write("alert('Saved Successfully')");

I was able to create the package manually for a text file sample.
But what i need is to iterate the files with in sub folders of a parent folder and save the records with in each file bulk wise by invoking the dynamic package created.

http://www.sqlservercentral.com/blogs/on-the-fringe/2013/08/25/creating-and-executing-an-ssis-package-programmatically/

above issue is happening only when the users concurrent count is 50 or above. I mean when 50 users are logging at the same time the time out issue is occurring. SP also and call from front end which is executing without much time delay until 50.

Do we increase the concurrent count of IIS or Sql?

Connection is closed.

I have registered the event handler once without unregistering for each loop cycles. But I am unable to list files since it is unable to pass additional parameters(Inward message types and their respective values) to the event handler SftpListItemReceivedEventHandler .

Code is as below:
#region ListInwardCBFiles
private List<sftpfile> ListInwardCBFiles()
{
_listSftp = new Sftp();
SFTPFile objSFTPFile;
List<sftpfile> ListSFTPFile = new List<sftpfile>();
try
{
if (ConnectSftp(_listSftp))
{
objSFTPFile = new SFTPFile();
foreach (InwardMessageType t in Enum.GetValues(typeof(InwardMessageType)))
{

foreach (CBExtension r in Enum.GetValues(typeof(CBExtension)))
{

_listSftp.ListItemReceived += client_ListItemReceived;//register
_listSftp.GetList(GetSFTPServerPath(Enum.GetName(typeof(InwardMessageType), t)) + "//" + "*." + Enum.GetName(typeof(CBExtension), r));

}
}

}
}
catch (Exception ex)
{
Common.WriteLog("Exception while listing files in the folder " + Environment.NewLine + ex.Message, ServiceThread.Listing.ToString());

}
finally
{
DisConnectSftp(_listSftp);
}

return ListSFTPFile;
}
#endregion


void client_ListItemReceived(object sender, SftpListItemReceivedEventArgs e)
{

var listItemReceived = new SftpListItemReceivedEventHandler((s, e1) =>
{
SftpItem item = e1.Item;

objSFTPFile.FileType = Enum.GetName(typeof(InwardMessageType), t);
objSFTPFile.Extension = Enum.GetName(typeof(CBExtension), r);
objSFTPFile.Status = SFTPStatus.L.ToString();
objSFTPFile.FileName = item.Name.Trim();
objSFTPFile.FileSize = item.Size;
objSFTPFile.Mode = SFTPMode.D.ToString();
objSFTPFile.BankCode = Common.BANKCODE;
ListSFTPFile.Add(objSFTPFile);
Common.WriteLog(MethodInfo.GetCurrentMethod().Name + " FileType: " + objSFTPFile.FileType + " FileName: " + objSFTPFile.FileName, ServiceThread.Listing.ToString());
e1.Ignore();
});

_listSftp.ListItemReceived += client_ListItemReceived;//register
_listSftp.GetList(GetSFTPServerPath(Enum.GetName(typeof(InwardMessageType), t)) + "//" + "*." + Enum.GetName(typeof(CBExtension), r));

}
}

}
}

Even if Boolean option set to listItemReceived() how can we avoid the duplication since we are looping through each message type and their respective CB Extension types. Need to list the files with all message type and CB extension type present in a directory.

the code level portion in the loop also is being updated.

but the need is to show all records which could be around 20k atleast. This is the need.

Is it possible to communicate (send/receive) message without installing MQ Client?

Getting Authentication Failed as in data variable on setting the debugger over the script. Then on reaching data.d.length portion getting the exception length is null or undefined

It is as per the code obtained.

Did as mentioned above. still getting the access denied option. I can open the file. But while trying to copy the file access denied issue shown after impersonate

string username = @"Alexander.junior@chn.nestgroup.net";
string password = "lordsusan126*";

//\\ntp-228\Alex\SIB_TEST

AppDomain.CurrentDomain.SetPrincipalPolicy(PrincipalPolicy.WindowsPrincipal);
WindowsIdentity identity = new WindowsIdentity(username, password);
WindowsImpersonationContext context = identity.Impersonate();
string updir = @"Z:\abcd.txt";
string destPath = @"D:\Alex_BackUp\Test\abcd.txt";

File.Copy(updir,destPath, true);
I am getting the access to the path denied option. Folder shared has admin privilege

Has edited my code.

My query is can we consume the local intranet Url of the webservice hosted of the machine with net connectivity.

How is it possible to translate arabic to english offline?

I want to check whether primary keys exists for tables with Identity Insert Columns query wise

I just want this for a single case.
Another case is if the OriginatorString could come as NTP-228 or [NTP-228]
On all occasions it must come as [NTP-228] always.

sill the exception of Xml data type is not supported in distributed queries. Remote object 'OPENQUERY' has xml column(s) is coming on executing above script

Multiple Tables will have xml data type and a generic script is required to convert the xml data type to varchar(max).

Below is the excel part using function GetfillData
#region GetFillData
//Copy the Standard Excel Template to DATA folder fetching PDF Data/Move PDF from the File Store to DONE Folder afterwards at last
private void GetFillData(string SourcePDFFullPath)
{

WriteServiceLog("" + SmartPDFLogCaption + "Entered " + MethodInfo.GetCurrentMethod().Name + " Method");
try
{

//Delimiter with which data is fetched from SMART PDF (split with '|')
Char delimiter1 = '|';
//Delimiter with which data is fetched from SMART PDF (split with '~' after spliting with '|')
Char delimiter2 = '~';

//Pass the PDF File in the FileStore
PdfReader pdfReader = new PdfReader(SourcePDFFullPath);
AcroFields pdfFormFields = pdfReader.AcroFields;
string PDFFileName = Path.GetFileName(SourcePDFFullPath);
//Get Template Id from Hidden Field(Template ID set Statically) in SMART PDF
string TemplateID = pdfFormFields.GetField("hidTemplateId");
//Get PDF Data in control fields from Hidden Field(PDF) in SMART PDF
string CapturedPDFValues = pdfFormFields.GetField("hidPDFDataExport");
string[] PDFValues = CapturedPDFValues.Split(delimiter1);

//Fetch Unique No(Quotation No) from PDF
string UniqueNo = PDFValues[0].Substring(PDFValues[0].LastIndexOf(delimiter2) + 1);
//Set Current Date while rernaming Excel Template in DATA Folder (ddmmyyyy format)configured in APP.Config
string CurrentDate = DateTime.Now.ToString("" + FileRenameDateFormat + "");


//Validate If the Template Id is empty for the PDF Files in FileStore Folder
if (TemplateID == "")
{
WriteServiceLog("" + SmartPDFLogCaption + "" + TemplateIdValidationMsg1 + "" + SourcePDFFullPath + MethodInfo.GetCurrentMethod().Name + " Method");
return;

}
//Capture PDF Data If the Template Id Exists for the PDF File in FileStore Folder
else
{
//Validate Excel Template exists in the Template Folder
string ExcelTemplateFullPath = string.Empty;
string ExcelExtension = string.Empty;
//Save the Excel Template with data in the Destination Excel Folder(DATA Folder in FileStore) with UniqueNo+Currentdate(ddmmyyyy format)
string DestinationFullPathExcel = string.Empty;
if (File.Exists(ExcelTemplatePath + TemplateNamingStart + TemplateID + ".xls"))
{
ExcelExtension = ".xls";
ExcelTemplateFullPath = ExcelTemplatePath + TemplateNamingStart + TemplateID + ExcelExtension;
DestinationFullPathExcel = DestinationExcelPath + TemplateNamingStart + TemplateID + "_" + UniqueNo + CurrentDate + ExcelExtension;

}
else if (File.Exists(ExcelTemplatePath + TemplateNamingStart + TemplateID + ".xlsx"))
{
ExcelExtension = ".xlsx";
ExcelTemplateFullPath = ExcelTemplatePath + TemplateNamingStart + TemplateID + ExcelExtension;
DestinationFullPathExcel = DestinationExcelPath + TemplateNamingStart + TemplateID + "_" + UniqueNo + CurrentDate + ExcelExtension;

}
else
{

WriteServiceLog("" + SmartPDFLogCaption + "Template Id:" + TemplateNamingStart + TemplateID + " doesn't exists in the Template Folder" + MethodInfo.GetCurrentMethod().Name + " Method");
return;
}
//Capture PDF Data If Template I

it's an account no: field which must have min 23 digits and it must be a unique number too

The files during release are set alongside with the PDF_Data_Tool exe. The bat file for installation/Uninstallation path is set where the release files in the folder.
set SERVICE_HOME="D:\New folder (5)"
set SERVICE_EXE=PDF_Data_Tool.exe
REM the following directory is for .NET 1.1, your mileage may vary
set INSTALL_UTIL_HOME=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\

set PATH=%PATH%;%INSTALL_UTIL_HOME%

when i tried to remove the constraint it shows it doesn't exists.

how to get the child table for the referenced Foreign Key Constraint?

how to get the values from Ienumerbale string list.
I tried looping
foreach(string file in fileList)
{

}
But not working

Resolved the same. it was developed as Console Application. Changed the Output Type to Windows Application and it worked.