I think you have issues understanding exactly what you need - a DATE field has no format.

you can convert a date to any format you want for writing to a...

don't do that on SSIS - do it on the select from the table where it will be a lot easier to do and will be faster than doing it...

do a query on the max and min values for r.ActualAllowed - that * 100.0 is most likely resulting on a bigger value than what a decimal can hold.

so casting...

unless you license your PC with a valid SQL Server Standard/Enterprise you can't do it for production purposes.

If you are not using those daily loads for production then you can...

we are in the process of deploying the packages to an integrated environment

What do you mean by that, as in deploying them to SSISDB? Are the packages all in...

have a look at the following links - they contain some good information even if not exactly what you are asking for.

and you may have seen some of them already.

you may need to speak with the supplier of the file and see how they are generating the file.

you could also try HxD (https://mh-nexus.de/en/hxd/) to edit the file and pick...

you may need to look at adding a codepage to your bulk insert command

or alternatively use powershell - but again you will need to specify the correct codepage to load...

it can be SQL Server - but without the code for both procs there's not much we can say

nearly there as not too hard to put a sample code was it?

unpivot has one small issue - the columns need to be hardcoded (or dynamic SQL used) and they...

• This reply was modified 5 years, 4 months ago by frederico_fonseca.

when volume of data changes so change plans - sometimes its just that.

could you supply us with the new explain plan - maybe that will tell us why but fact...

lets see if I can

a recursive CTE works by having a "anchor" set - that is the sql before the union. - this is the start point for all records...

I think that you can do that using another CTE.

and I do advise the use of () around the formula blocks so there is no ambiguity of what is calculated...

google for unpivot - or use a outer apply selecting each column and its value with a case statement and a group by

when you have some code showing what you...

• This reply was modified 5 years, 4 months ago by frederico_fonseca.

SSDT is for the client machine to develop the packages - Not to be installed on the server

Note that to load CSV/Excel files you do not need SSDT - that...