Hi

The Excel driver recognizes only a limited set of data types, please refer https://msdn.microsoft.com/en-us/library/ms137643.aspx.

You can cast all char (varchar) datatypes to nchar (nvarchar) in your view or add Data...

Hi

Two points:

1. @datasrc - host name of postgres service, ping to be sure that dns resolves it correctly.

2. Try to set ip and port in @provstr.

Best regards

Mike

Hi

I met similar problem, a few years ago I was involved in central repository project.

It had to move files prepared by users (local servers in branches) to the central server...

Hi

I think SSIS should be sufficient to do this.

You only need to create simple package with some components (Ole DB Source, Excel Destination and Send Mail Task).

It's enough to add...

I had always used Eclipse for modeling ERD since I started using it in high school.

Regards

Mike

Hi

Try this:

alter table your_table add group_col AS CHECKSUM(col1, col2, col3)

Br.

Mike

Hi

Could you check this link https://www.mssqltips.com/sqlservertip/3195/finding-execute-dts-2000-package-tasks-prior-to-upgrading-to-ssis-packages/, this document should help you.

Br.

Mike

Hi

Imho it's better (faster) to backup and restore a database to a new location.

Best regards

Mike

I was sure it returns error that there's no possibilty to prepare the plan. :ermm:

Thx

Hi

Sorry for lack of explanation from my side, regarding your questions:

Can you tell me why i need to add the folder to run 64bit mode?

I put it as an option...

Hi

Please add folder C:\Windows\System32\config\systemprofile\Desktop

(to run 64-bit mode C:\Windows\SysWOW64\config\systemprofile\Desktop).

Best regards

Mike

Hi

Please set Run64BitRuntime to false in your Package and check again that

the account running the SQL Server Agent have permissions to the files and folders involved.

Best regards

Mike

Hi

I'm afraid your screenshot is unavailable for us, please tell me source and dest dir are local or network paths?

Best regards

Mike

Hi

Is there any contraindication to do that on t-sql level and use single data flow?

Regards

Mike

Hi Jack

Please check this out:

WITH rt (rn, date,contact,ammout) AS

(SELECT ROW_NUMBER() OVER (PARTITION BY s1.contact ORDER BY s2.date) AS rn ,s2.date,s1.contact,s1.amount from tb2 AS s2 LEFT OUTER JOIN tb1 AS...