kick off the install as an administrator explicitly - right click and "run as administrator"

well. half that page is talking about cache sizes and management so in my opinion it was enough to guide me - note that cache management is only an issue...

reading the manual helps - that is why it was written.

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-ver15

its possible that the 2 db's are in different compatibility level

Select b.* from #Imports
  CROSS APPLY dbo.UDF_datasummary(a.HS_code) b

missing alias - "a"

I would start by giving all tables a short alias (some tables do not have any) and use it in all respective columns so it is clear to anyone which...

the user that the instance runs under may not have access to that folder - check permissions

Not sure I understand what you are saying...

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

Brandy - you were asked to look at Windows Event Viewer and at msdb sysssislog  - do you have any of the messages logged there? if not can you change...

easy search with google (https://www.google.com/search?q=IANA+timezone+names+c%23) and the following is one of the first hits.

https://github.com/mattjohnsonpint

there may be others

you can code it in a c# script within ssis - most likely there are already functions to do that including .net native ones.

event viewer - see this link for some info https://docs.microsoft.com/en-us/sql/integration-services/performance/events-logged-by-an-integration-services-package?view=sql-server-ver15

better to run packages on filesystem or catalog - easier to check errors and easier to change...

event viewer - see this link for some info https://docs.microsoft.com/en-us/sql/integration-services/performance/events-logged-by-an-integration-services-package?view=sql-server-ver15

better to run packages on filesystem or catalog - easier to check errors and easier to change logging level

as far as I know yes

Command line setup is quite used for automation but this is one of the cases where doing on command line is likely to b e...

argh. clicked the report button by mistake - can some admin undo it please.

changing server collation is fully documented and supported by Microsoft - although the link I gave above...