Viewing 15 posts - 1 through 15 (of 206 total)
Thank You for your reply. Do you have any example or anything that I can take a look?
February 12, 2019 at 12:15 pm
I don't have words to say THANK YOU for your help. Very professional way to help.
I appreciate it. I will apply this logic and run through...
October 16, 2018 at 10:01 am
Ohh K. Can you share your stored proc if you already have written? Maybe I can use the SQL Script task to move the data from .txt to staging SQL...
October 15, 2018 at 9:53 pm
What Expression value should I give for "LastRow" parameter?
October 15, 2018 at 9:41 pm
Sorry, I miss understood your last question. Yes, I already have mapped those fields in SSIS.
October 15, 2018 at 9:07 pm
Yes, Exactly same fields and both files are going into the same table except one file has one extra and others don't. Can you share your test .dtsx package?
October 15, 2018 at 9:04 pm
To access BCP file will be a little bit challenge for me to convience IT.After I come up with the solution I have to focus on performance because from...
October 15, 2018 at 8:09 pm
Hi Jeff, Thank You for your time to reply. I was thinking, If I could create two Data Flow1) DF with Row Delimiter "LF" with 275 character2) DF...
October 15, 2018 at 7:39 pm
Thanks let me test it. However, I am stuck with, how to pass file names to all 10 child packages.
What I did so far, loop through all files...
August 16, 2018 at 10:04 am
Yes, all are going to the same table but the different batch. Any other better advice to accomplish this?
August 16, 2018 at 8:16 am
Hi Frederico,Thank you for your time to comment. I am sure you already read "it is a SAMPLE data". The client is sending the data from "SalesForce" system.
May 18, 2018 at 4:05 pm
Is someone can help me to write a code to add "RankID" column in my source file?
Sample Source Data
March 3, 2018 at 4:54 pm
March 3, 2018 at 4:54 pm
If I can add "RANKID" in my source then I can easily Pull my data through above While Loop. Here is source table as an example.
RankID,Source_id,sta_id ,Address1 ,City ,PaymentMethod,Invoice_Detail1 ...
March 2, 2018 at 5:01 pm
Sorry If I confuse you. Yes, first I said my source is SQL and yes the original source is my .txt. I thought it is easy for me to load...
March 2, 2018 at 4:52 pm
Hi John,Thanks for your time to reply. In above code, I missed important source field "Source_ID" that will tell where the batch start and ends.
John, I was...
March 2, 2018 at 8:44 am