Forum Replies Created
Viewing 15 posts - 1 through 15 (of 51 total)
-
Reply To: Query about GAC (Global Assembly Cache)
Phil Parkin wrote:So my question is how can I add these nuget/dll files into ".SSISDeploymentManifest" and install them automatically when I am deploying the package?
As far as I know, you cannot. Adding the...
-
Reply To: SSIS Execute Package Utility Issue
Phil Parkin wrote:Are you using a third-party library to convert PDF to Excel? If not, how are you doing it?
Sorry for late reply. I found the solution. It was because of...
-
Reply To: Convert PDF to EXCEL or CSV using SSIS or C# ?
Phil Parkin wrote:As far as I know, C# cannot do this conversion natively.
NitroPDF does not appear to have an API, so its functions cannot be called from other applications. You'll have...
-
Reply To: SSIS Config File Query
Phil Parkin wrote:Assuming the package is deployed to SSISDB, it is possible to execute it by calling a stored procedure.
Stored procedures can be called from a SQLCMD command line and parameters...
-
Reply To: How to replace these special characters?
frederico_fonseca wrote:but this leads to the question - why do you need to remove them? they are valid characters and if the output is being displayed anywhere for users removing...
-
Reply To: How to replace these special characters?
Phil Parkin wrote:They are different characters and therefore multiple nested REPLACE commands would be required.
DECLARE @x VARCHAR(50) = CONCAT ('Some''', CHAR (96), CHAR (145), CHAR (146));
SELECT @x
... -
Reply To: Extracting Data from XML file
Dennis Jensen wrote:I am not sure if this will help any but LMGTFY got the following item that might prove useful. However, as Phil Parkin pointed out this is an SQL...
-
Reply To: Fetching data from WEB API using SSIS
frederico_fonseca wrote:what errors you getting? and did you try debugging the code in case the error you get does not reflect the true error?
Yes I have tried few things....
-
Reply To: Issue importing data to SQL table
Jonathan AC Roberts wrote:If you just want an id you can just add
ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) id,as a column to the query to get a sequential id column.... -
Reply To: Issue importing data to SQL table
Phil Parkin wrote:Generate your own would appear to be the next resort.
If you open the link, there is a PDF option as well.
Is there anyway to import PDF file data to...
-
Reply To: Issue importing data to SQL table
Phil Parkin wrote:What do you mean by 'fix' exactly? Do you want to generate a unique Id yourself?
I can generate my own uniqueID and I did that too but there is...
-
Reply To: SQL Table Issue
Phil Parkin wrote:Not directly related to your issue, but there are a couple of good-practice items I suggest you consider:
- Always qualify your tablenames with their schema
- Try not to include...
Viewing 15 posts - 1 through 15 (of 51 total)