You are viewing limited content. For full access, please sign in.

Question

Question

Settings for txt file data source - Workflow Designer

asked on November 25, 2016

I have a client that wants to use a txt file as a data source. They said they had this working a few years ago but think that they are missing drivers. When I look at direct connections for configuring a data source in workflow designer it doesnt look there are any options for a txt file. 

 

Do I need to download a specific driver?

 

 

0 0

Answer

SELECTED ANSWER
replied on November 25, 2016

Hi  Ben.

It´s look simple do not worry about that I attached a video of how to do it.

But when we talk about TXT files I will prefer always to make a bulk statement on sql bring all that info into a Table or  a variable as table and work with a "for each row" node, seem cleaner to me.

Regards!!
 

TXTSource.mp4 (3.08 MB)
2 0

Replies

replied on November 25, 2016

I have found you need to download and install the AccessDatabaseEngine.exe or AccessDatabaseEngine_X64.exe (based on 32 or 64 bit OS) from Microsoft for the OBDC connections to work

https://www.microsoft.com/en-ca/download/details.aspx?id=13255

1 0
replied on November 25, 2016

Thanks David, 

For some reason we are missing all the ODBC drivers so it was very helpful to see how it should look. 
 

0 0
replied on November 25, 2016 Show version history

Thanks to you Ben.

Try  bulk statement on sql wink Trust me I been there.

Regards!!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.