FilePointing from SQL DB to TB data drive

[benjatado]

I need to reference terra bytes of data files that correspond with my SQL data, however I do not know how to load this data/ reference this data from SQL?
How can I load the reference to each file into a table in SQL?

 

[JayKusch]

What kind of data are we trying to import into SQL Server.

Another question is how the data in your extenal files will link w/ your data in the SQL Server. Is there some identifying field, or column that contains the name of the external file?

Thanks

J. Kusch

 

[benjatado]

I am working with audio files...
But I do not want to import these files into the SQL just to point to the files which are contained within a directory which is named after the ItemID in SQL.

In SQL -
ItemID ('20804')

In H: drive

H://Audio/20804/Track1.wav etc...

 

[JayKusch]

OK ... lets take a crack at it ... Quick and Dirty

If we have a table called:

MyAudio and it has fields called:
========
ItemID Integer
DrivePath VarChar(100)

You could build the path somewhat like ...

UPDATE MyAudio
SET DrivePath = CONVERT(VarChar,ItemID)

UPDATE MyAudio
SET DrivePath = 'H://Audio/' + RTRIM(LTRIM(ItemID)) + '/Track1.wav'

Thanks

J. Kusch