Viewing 15 posts - 2,041 through 2,055 (of 13,838 total)
I checked the column count in SQL Server table and it matches the number of csv columns.
This is not the important thing. You need to look inside the...
May 11, 2021 at 5:40 pm
Sounds like it is expecting (n+1) columns rather than the (n) that are there. Why not fix that, rather than modifying the input file?
May 11, 2021 at 3:54 pm
Why is the final comma needed? My CSV files don't need one.
May 11, 2021 at 3:46 pm
Have a look at the first answer here: https://stackoverflow.com/questions/36116795/how-to-update-a-record-in-text-file
As long as your file is not too huge, that gets you pretty close.
May 11, 2021 at 3:20 pm
Yes, a C# script could definitely do it.
May 11, 2021 at 2:58 pm
Phil Parkin wrote:250 seems like a lot of facts! Are you happy that you've got the data modelling correct?
Not sure I understand what you are saying Phil.
I'm used...
May 10, 2021 at 2:11 pm
Per our CISO we have to set the protection level to EncryptAllWithPassword
We are using SSIS packages just to move data from one table to another and it contains...
May 9, 2021 at 7:32 am
No. I suggest you change the protection levels on the project and all its packages to DontSaveSensitive.
If you need to pass sensitive info into the packages at runtime, use Sensitive...
May 8, 2021 at 8:19 pm
Looks like an issue with access rights. Are you sure that the user (as shown in the All Executions report) has full access to the object?
Also, are you inserting data...
May 8, 2021 at 8:10 pm
250 seems like a lot of facts! Are you happy that you've got the data modelling correct?
May 8, 2021 at 8:06 pm
You are displaying the properties for a data flow task.
Instead, click on a blank area on the Control Flow window and you should get the properties for the package.
May 8, 2021 at 8:04 pm
You want your proc to have two options? Like 'Incremental' and 'Full', is that right?
Full is easy, just add:
TRUNCATE TABLE ...
INSERT TABLE ... results of proc
to your proc.
Incremental is harder,...
May 7, 2021 at 11:19 am
Sorry, but I really have no idea. Never seen anything like that.
But if you are opening the .sln, you should not be having a problem with the project-level connections, so...
May 6, 2021 at 4:50 pm
What problem does this cause? Can't you just set the protection level manually?
Was the package developed in 2019, or could there be versioning issues?
If the original developer used project-level connections,...
May 6, 2021 at 4:38 pm
Viewing 15 posts - 2,041 through 2,055 (of 13,838 total)