May 18, 2012 at 2:41 am
Hi Guys,
I've received a set of files.
The files can be grouped, with 3 files per group.
For example:
AT_Category.bcp -- suspect this contains data
AT_Category.cft -- Can read in text editor; contains table definition
AT_Category.dri -- Can read in text editor; contains relational constraint(s)
From what I am able to find on the web, it seems that this is the file form of snapshot replication?
I need to construct a database (schema + database) from these files.
The provider will not change their output format.
Could anyone suggest a workflow?
At least a method of getting the data in a readable format in SQL Server?
The closest thing I have come across is OPENROWSET - but I have no idea of what provider to use.
Thanks in advance!
May 18, 2012 at 11:17 pm
1/You can build a package in SSIS (Integration Service) to do that automatically.
- Extract the group file into the folder where you want to store
- Use import/export components in SSIS to read .bcp file. As you know, .bcp file is form of a snapshot replication.
2/ You also use Import/Export utility in SQL Server Management Studio to read bcp file if you only want to import data from bcp file manually.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply