Viewing 15 posts - 616 through 630 (of 2,648 total)
So all the SSIS package does it call a SP and generate the file? or does any type of transformation on the data it gets from the SP?
if no transformation...
January 11, 2023 at 12:00 pm
Assuming the package has been deployed to SSISDB, it may be called (with parameters as needed) from a stored procedure. Would that help?
likely not - SSIS catalog does not...
January 11, 2023 at 10:49 am
spam - exact copy of https://www.reddit.com/r/AZURE/comments/sb09bg/azure_pricing_sql_server_seems_pretty_high/ from Jan 2022
January 9, 2023 at 6:15 pm
without the full code (insert + table ddl) its not possible to state the exact issue - but I would guess the order of the columns being inserted do not...
January 9, 2023 at 5:08 pm
CR LF is breaking my data load into mysql, I have updated CR LF as space ' ' and load is working good.
it is not breaking it - you...
January 9, 2023 at 5:05 pm
I thought of using quotename. select * is not working some places found that because of CR LF.
select * does NOT CARE about CRLF - other than the thread...
January 9, 2023 at 10:00 am
but why do that update? if the data is there it likely has a good reason for it and should not be changed on a whim. (specially not if it...
January 9, 2023 at 9:58 am
HI,
fields terminated by "|" (the delimiter you used above), enclosed by '"' escaped by '"'
I have used the same test. But wherever there is a split it load as...
January 6, 2023 at 9:08 am
Thanks for the CR LF note, I am trying to bcp out from mssql and load to mysql.
if that is the case then doing what I stated is what...
January 5, 2023 at 4:56 pm
reason why you have your records split like that is because the data on those columns contain a CR or a LF or both - in order to be able...
January 5, 2023 at 9:09 am
you have already been given the answer to your last (and prior questions) - if they are above your head then consider hiring a professional (as you have been advised...
January 4, 2023 at 8:49 pm
you made it clear that you do not wish the job to run on the first of the month if it it is on a Sunday - but what do...
January 3, 2023 at 7:42 pm
spam - exact copy of https://www.reddit.com/r/aws/comments/100je4m/step_functions_trigger_rule/
January 2, 2023 at 10:59 am
Is this solution is only good if there are no dates falling on weekends?
what mention of weekends? there is nothing on the original OP post that mentions...
December 31, 2022 at 5:20 pm
Is this solution is only good if there are no dates falling on weekends?
what mention of weekends? there is nothing on the original OP post that mentions it neither...
December 31, 2022 at 3:00 pm
Viewing 15 posts - 616 through 630 (of 2,648 total)