Import Simple File by SQL Server Magement Studio giving Expired Run Time Out error

Asked

Viewed 29 times

0

Hello.

I am using the "Import Simple File" wizard from SQL Server Magement Studio to import a 2GB TXT file into a SQL Server Express database. I follow the entire process of the wizard, it recognizes the columns correctly, but after a few minutes running gives the following error:

TITLE: Microsoft SQL Server Management Studio

Running Time Out Expired. The timeout ended before the operation is complete or the server is not responding. (Microsoft.SqlServer.Import.Wizard)

ADDITIONAL INFORMATION:

Running Time Out Expired. The timeout ended before the operation is complete or the server is not responding. (Microsoft SQL Server, Error: -2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

The waiting time limit has been reached

How do I increase this time, or leave him without limits?

Thanks in advance. Thank you.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.