Viewing 15 posts - 1 through 15 (of 50 total)
THANK YOU! I wanted all rows of data from ALL columns in my "Import" table to be inserted into my "Destination" table, I had a duplicate column name due to...
May 12, 2022 at 8:24 pm
Your query worked perfectly and simply adding "Insert Into MyTableName" above it did exactly what I needed it to do. Thank you.
Now, I can build my SSIS package...
March 24, 2022 at 1:30 am
Another thing that is strange is that in SSMS 18 (17 was the same from memory) if you want to import Excel files you need to save the file...
July 15, 2021 at 9:32 pm
I really appreciated this article. It made me feel better about my skills (or lack of!). Reading the other comments about how others are import CSV files, which should be...
July 15, 2021 at 9:29 pm
Thanks for your help on this. I too realized my two CASE statements had to be exactly identical, and they were not.
@jeff - I thought about the CTE...
May 11, 2021 at 4:25 pm
Disregard. I found my error. 🙂
May 7, 2021 at 8:40 pm
Thanks, Jeffery. Learned something new, again. I've applied this to my actual query and it works, as I had hoped now.
May 7, 2021 at 8:09 pm
Jeffery,
I had to slightly modify your PowerShell suggestion. The first line is as shown below and that 'works' (as in no error reported)
$recordData = Invoke-SqlCmd -ServerInstance localhost...
February 23, 2021 at 9:37 pm
I have a working solution after trialing several suggestions from here.
First I tried the PowerShell ISE route by saving my query to a file with the concat method in it:
February 22, 2021 at 7:45 pm
Jeffery,
I don't know if the recipient of the data truly needs it sorted in order by the Row_ID field. I'll have to ask them or if it's nearly an identifier...
February 18, 2021 at 5:17 pm
I thought about doing a new Row 1 with just these items and then filling in the following columns with empty data and then a Union All, but...
February 18, 2021 at 3:46 pm
Currently, all the detail data is in one table that gets refreshed each month.
Could you post the CREATE TABLE statement for that one table and also identify...
February 18, 2021 at 3:16 pm
Thanks for your tips. I am going to see if I can get something working with SSIS tomorrow or Friday.
February 17, 2021 at 9:42 pm
Jeff and Jeff -
Currently, all the detail data is in one table that gets refreshed each month. I'm not terribly good with SSIS. I am just now figuring out how...
February 17, 2021 at 7:38 pm
If I am understanding your question correctly:
The main export data output is 85 columns. They must be delimited by the bar character per the recipient's requirements. The end result should...
February 17, 2021 at 6:19 pm
Viewing 15 posts - 1 through 15 (of 50 total)