Thanks you very much for your reply.

You are right eventually i need to learn C# scripting or VB scripting in order to work on SSIS.

Let me know if your have...

Hi,

Thanks you very much for your reply but my problem is i can write sql code but i can not write script task(C# Code and VB code)

I really appreciate if...

Thank you very much for your help.

Yes this is good solution.I will put this code in store procedure and run it through Execute sql task.

Thanks,

Unnati

Hi, Thank you very much for the code

But I need to check that if the Date is valid or not

Lets say if we pass this SourceFile1_99999999999999.txt then should...

Hi,

Thank you for quick reply but i do not understand the SQL function for this?

Can you please tell me about that function?

I appreciate if you can give me steps for...

Thanks Steven Willis.

That is what i was looking for. it was awesome logic.

I have another question.

Once i identify the node and tag i need to load the data into normalized...

Thanks Steven Willis

I have another questions. if my XML files contain so many Node around 100. i need to load into more then 100 tables and each table contain...

Awesome Logic..

Thank you very for your quick reply.

it works good.

i got it.

Thank you very much for your help once again.

i got it.

Thank you very much.

Thank you very much Thats perfact.

i appreciated!!

Thank you very much..

i got my answer

Hi,

Thank you very much .. i got my anwer..

i really appreciated..

Hi,

Thank you very much i got my answer.. i have to define the datatype as xml(.) and just insert xml values in that perticular column.

i appreciated for your response..

Thank...

yes i lookng for something like that.. when you click value in column it will open the xml coding in SSMS..

Thank you..

HI

Yes i want query data in XML format..

i want something like you have column name is 'subscription'

in that column you store some xml link..

and when you open that...