I did search for the answer and found few examples here:

https://www.mssqltips.com/sqlservertip/7233/sql-pivot-sql-unpivot-examples-transform-data/

e.g.:

SELECT 'SalesYTD' AS SalesYTD, [Europe], [North America], [Pacific]

FROM

(

SELECT SalesYTD, [Group]

FROM [Sales].[SalesTerritory]

) AS TableToPivot

PIVOT

(

SUM(SalesYTD)

FOR [Group] IN ([Europe], [North America],...

Brilliant!  Thanks!

Hi,

I have to import csv files with hundreds of columns and only few thousands of records.  The flat file import wizard does not do full sampling and may...

• This reply was modified 3 years, 6 months ago by  Roust_m.

Are you processing the same files each day/week/month?  Or is every single file completely different from previous files processed?

If this is a process that repeats with a new file...

Yep, that exactly what it was.  Some junk at the end of the file.  I deleted few empty rows at the end in excel and it worked.

You might want to review this article: https://www.sqlservercentral.com/articles/auto-assign-column-data-types-for-flat-file-source-import

It outlines a method of using the destination table to define a destination and then 'swapping' that for a...

Unfortunately, the short answer is 'no and no', to the best of my knowledge.

Regarding your second point, the 'pure' SSIS way of handling this is to send all...

My opinion on the fix - try checking off the other box in the Exchange configuration (use windows authentication) UNLESS you are not using windows authentication for Exchange...

The events are shown in Microsoft Cloud...

Enabling SSL would encrypt the connection between the source and destination.  One of the main benefits of SSL is that MITM (man in the middle) attacks don't work...

• This reply was modified 3 years, 6 months ago by  Roust_m.

Hi,

I have a job running SSIS package, which has 2 sql server connection managers using sql logins, one connection manager to a local log file, one...

Found a solution in case someone may need it:

param($BackupFolder, $S3Bucket, $s3Folder, $Filter) 
$erroractionpreference = "Stop"
<#
$BackupFolder = 'F:\Backup'
$S3Bucket = 'mybucket'
$s3Folder = 's3myfolder'
$Filter = '*.zip'
#>

# Get the AWS Stuff
Import-Module...

Yes, it copies the same files.  If I run it twice without adding any new files, it would copy over all files again.

It is an AWS EC2 instance.  But it does not matter, as long as there is connectivity.  I am trying to copy my folder structure to AWS without overwriting the...

Spasibo!