Viewing 15 posts - 1 through 15 (of 15 total)
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 set...
January 24, 2022 at 1:16 pm
You might want to use a script to update your variable values rather than use an expression since you are updating every time the package is run.
November 21, 2019 at 9:00 pm
It sounds like the query you are running to merge into the table is returning duplicate rows. The merge statement requires each row to be unique.
October 10, 2019 at 7:37 pm
That would be very helpful. Maybe I just don't know how to build the formula -- I keep getting errors. I'm not much of an SSRS developer:)
August 2, 2018 at 1:45 pm
Because the text box that should display the report title is not on a data regain, it is in the main report's page header.
August 2, 2018 at 10:11 am
Not that doesn't seem to work as the field is not visible to the main report.
August 2, 2018 at 9:31 am
There is a bookmark and when the bookmark is clicked the report shows. The report is hidden or visible based on the bookmark value. The funny thing is when we...
August 2, 2018 at 8:33 am
I figured it out. It was the sizing of the body within the report.
July 11, 2018 at 1:09 pm
Thank you! That worked for me.
November 30, 2017 at 8:14 am
What we found is that one of the underlying tables used in one of the views the query uses had 20 million + rows. Rebuilding the indexes prior to...
January 4, 2017 at 5:40 am
Thank you. The following is my script. In the last query I want only rows where the login name is Sam.Smith or Michael.Jackson.
CREATE TABLE #tmp (loginName VARCHAR(50))
INSERT...
October 7, 2016 at 7:16 am
Yes, it was. I think I found the issue. When I export the package, it is defaulting the protection level to "EncryptSensitiveWithUserKey" and I need to change this...
September 21, 2016 at 8:14 am
I tried another approach to my deployment today. I connected to Integration Services from SSMS and then used the import package feature there to import the package. When...
September 21, 2016 at 6:06 am
you may want to check for the existence of all the file in one script and return true if they all exist. true will be a precedent constraint on...
December 31, 2015 at 12:26 pm
Viewing 15 posts - 1 through 15 (of 15 total)