Viewing 15 posts - 76 through 90 (of 505 total)
I know I know, lol after I posted that I realized what I did and couldn't figure out how to delete. Also in no way did I mean to imply...
February 24, 2021 at 5:46 pm
EDIT: Sorry, I wrote that other post incorrectly nevermind, hey how do you delete a comment?
Phil, the SET RESULTS SETS is outside of the procedure and used to re-define the...
February 24, 2021 at 5:08 pm
I don't ever run packages from the catalog directly but I did create a simple ETL using a stored procedure for the source with the SET RESULT SETS clause and...
February 24, 2021 at 4:30 pm
I've used stored procedures as OLE sources but never included "WITH RESULT SETS" so I don't know what impact that has but the fact that it works in dev leads...
February 24, 2021 at 3:16 pm
Correct no updates, when a new file is generated it's read and combined with the meta data then inserted.
There are only 2 rows with less than 8K and these would...
February 22, 2021 at 5:31 pm
Just checked with the developer and rows are created all at once with no updates.
February 22, 2021 at 4:07 pm
It might be the default but doesn't apply in this situation.
0 = varchar(max), nvarchar(max), varbinary(max), xml and large UDT values are stored directly in the data row, up to a limit of 8000 bytes and...
February 19, 2021 at 6:13 pm
I thought the default was off row when the value exceeded the page size.
There can be updates to these documents (the column contains a text file that is about 6-8...
February 19, 2021 at 5:31 pm
OK so when you're logged into the server you can access the file via the run command. which means your account that you log into the server with has access...
February 19, 2021 at 4:21 pm
I'm a little confused, you say the "server" has access to the path what does that mean?
The account used to execute the package must have access to the files.
Also if...
February 19, 2021 at 4:01 pm
yeah, sorry I misread the original, thought you were having an issue on the server.
February 8, 2021 at 4:44 pm
These problems are almost always security related.
Your proxy account has access to this location? Or if running as the agent then your agent account has access here?
Could always try running...
February 5, 2021 at 5:41 pm
When we need a dynamic query against DB2 we use variables to contain the SQL commands then use expressions for subbing in parameters. One reason we do this is to...
December 18, 2020 at 6:16 pm
Thanks Jeff, and no not hell bent, I liked your explanation and that query.
We do native SQL backups but they are triggered by a separate system that manages all backups...
December 11, 2020 at 11:15 pm
If you just use the following it should be doing what you want. If either is true it will be disabled.
@[$Project::DISABLE_TILDE_RELOAD] || @[$Project::DISABLE_ARCHIVE_RELOAD]
If this is not doing...
December 3, 2020 at 5:03 pm
Viewing 15 posts - 76 through 90 (of 505 total)