Viewing 15 posts - 151 through 165 (of 2,893 total)
I had to do something similar, importing a .CSV , but at least the date field was in it's own column
Month and day did not have a leading 0, so...
March 1, 2022 at 5:09 pm
Hey SQLAddict01
What did you end up doing? I have similar issue. I have last 3 months worth of data that is being used most of the time. Remaining 2...
February 24, 2022 at 9:15 pm
Thank you for your reply. I'm sorry for being such a beginner. Can you give me an example of how I would use SET to acomplish what I am...
February 17, 2022 at 2:41 pm
........... And understand the impact on your indexes from shrinking data files.
February 10, 2022 at 4:50 pm
Someone needs a "dope-slap" !!
"... someone expanded a string in a source component, didn't tell anyone, ..."
February 7, 2022 at 10:07 pm
Setting up transaction log backup is just a few different clicks. Jeffrey Williams' advice is good.
You can use a Maintenance Plan wizard and it's quite easy.
Make sure the database option...
February 7, 2022 at 3:38 pm
Edit: Duplicate post
February 7, 2022 at 3:37 pm
Thanks, I used SSIS to write file locally, then DOS COPY in a .BAT file to move it to the remote server.
Just curious - why not use the...
February 4, 2022 at 7:32 pm
Extended Events is our friend.
Take a look at the object_created event. You could filter by object_type and only see when indexes get created.
That will only work after...
February 4, 2022 at 4:25 pm
Thanks, I used SSIS to write file locally, then DOS COPY in a .BAT file to move it to the remote server.
February 3, 2022 at 9:56 pm
I was able to do it in SSIS by creating a separate "Preparation Task" and "Data Flow" task for each Excel spreadsheet tab.
January 31, 2022 at 6:03 pm
One more question ...
From a design perspective... is it better to have one script do it all or should there be different SSIS tasks for each?
My personal preference is...
January 25, 2022 at 2:07 pm
Looks like you need BIGINT instead of INT.
Max for INT is 2,147,483,647
Your value is 16,520,105,984
January 24, 2022 at 4:39 pm
I would try doing the insert in batches based on the primary key or another integer. Create a while loop based off the key field and insert a smaller...
January 24, 2022 at 4:17 pm
Most vendors will give you a free trial period, so you can see which you like best.
At least one of them I remember giving a 2nd block of free time...
January 24, 2022 at 4:10 pm
Viewing 15 posts - 151 through 165 (of 2,893 total)