Viewing 15 posts - 2,026 through 2,040 (of 13,855 total)
As you are familiar with SSIS, you will probably know that you can redirect errors to an error table.
If your target staging table is set up with all of the...
May 21, 2021 at 3:23 pm
What action do you wish to take if validation fails (eg, invalid date) for a particular row?
May 21, 2021 at 7:44 am
To fix the issue with not being able to edit scripts - you need to repair 'Microsoft Visual Studio Tools for Applications YYYY'. This happens almost every time you...
May 20, 2021 at 4:40 pm
Not sure about stopping it, but looks easy enough to handle in the proc, based on the differing lengths of the incoming string.
May 20, 2021 at 2:41 pm
Aha, you're using Polybase. I thought you were using 'external' to mean 'somewhere not on this database/instance'!
I have not used it and therefore can't help, sorry.
May 20, 2021 at 2:03 pm
I have no link for VS Pro, you need to buy it or create a VS subscription.
Before you do that, can you try creating a brand new package and adding...
May 20, 2021 at 1:29 pm
Sorry, I am new for cloud technology. so external here means we only store metadata of tables in our Azure SQL database that exist in other Azure SQL database....
May 20, 2021 at 8:32 am
One more issue arose. I cannot edit my C# Scripts... I hit the button and C# won't launch... I ran the repair on VS 17 and restarted my machine...
May 20, 2021 at 8:29 am
Thanks Phil. I'm going to update my packages to use the environment variables.
Still curious, what might caused this change since everything worked fine before.
Jay
Possibly something to do with ProtectionLevel,...
May 20, 2021 at 8:26 am
I would add an ORDER BY Id clause to your SELECT, to help ensure consistency between the two versions of the query.
May 20, 2021 at 8:24 am
Out of interest, could you explain the background to this requirement?
Have you thought about tracking down all missing schema references in the master (I assume 'dbo') schema and adding them?...
May 20, 2021 at 8:22 am
I would have expected it to report a failure in that case, but to be brutal you could add a Script Task to your OnError handler which does this:
May 20, 2021 at 8:11 am
Sensitive data like passwords are usually not stored inside packages, for security reasons.
Instead, they can be stored in SSISDB environments and marked as 'sensitive'. Once you have the password stored...
May 19, 2021 at 8:06 pm
What do you mean by 'external' exactly?
May 19, 2021 at 8:03 pm
I had to uninstall everything to clean things up. Should I install VS before the link you posted?
Assuming you have full VS Pro, yes.
May 19, 2021 at 4:34 pm
Viewing 15 posts - 2,026 through 2,040 (of 13,855 total)