Viewing 15 posts - 1 through 15 (of 227 total)
The package was completed successfully. I checked through the SSIDB category, and it shows run and finished fine. However, the SQL Agent Job keeps running and never stops.
First, I used...
April 1, 2024 at 3:59 am
Thank you, Ken and Phil. This is exactly what I am looking for. I ran it to my real data and it works perfectly.
Thank you, SSC. I will check out...
February 1, 2024 at 5:24 am
Thanks, Drew for your reply. Did you bother to read my latest post? and did you bother to run the query that I provided?
IF yes, then my question was in...
October 12, 2023 at 5:23 pm
I want to say thank you very much, everyone. After I carefully reviewed our data and created a sample data. It looks like I need "gra" number based on the...
October 12, 2023 at 4:13 pm
Thanks for your reply.
My question was, I want to Loop through the whole table, If we met the criteria listed above then 0 else Previous "GRA" value +1 until we...
October 12, 2023 at 2:57 am
Hi Steve,
It works for the sample data. I am sure it will work on the original data as well. I marked this question as answered. I appreciate your help.
July 19, 2022 at 3:44 am
Here is the SQL script, if someone is looking for a solution.
select top 1 t.*
From test_dup src
join test_dup t on src.f_name = t.l_name
and...
May 21, 2022 at 5:58 am
Hi, ratbak,
Thanks for your help. It worked.
SELECT d.id,d.fullName,d.city,products.value
FROM ##Data d
OUTER APPLY string_split(product_descr,';') products
"Answered"
April 13, 2022 at 7:28 pm
Hi Jeff,
By chance, do you have an example that I can take a look at in the script task calling the .exe file and pass and return the variable value?
Thanks,...
June 17, 2021 at 4:06 am
Thank you, Scott!
I really appreciate your time to help me and write the query.
Looks good!
May 19, 2021 at 4:20 am
Thanks for your reply. The PowerShell script is calling a third party .exe file and getting username and PW. I will give a try using C#. However, my biggest concern...
November 8, 2020 at 7:59 pm
Thanks for your reply. Yes, I am calling PowerShell script from SSIS (Execute Process task).
I have a couple of options that I can take.
November 8, 2020 at 5:01 am
Hi ratbak, thanks for your advice, and it works. However, it works if its a truncation error. How can I capture if my source is varchar and destination is numeric,...
October 2, 2020 at 3:49 am
Viewing 15 posts - 1 through 15 (of 227 total)