do you mean dynamically select a query and result set, and use SSRS to export it to doc/docX? if that's the question, i don't believe you can. i'm awful sure...

if the service is running, it's not possible to delete the master database either accidentally or on purpose; it has a file lock on it by the SQL Service.

if the...

you'd have to add something to the table ; either a new column of type datetime, plus a trigger to always populate it on update, or a column of type...

ok , the issue is this is one of those file swhere there's layers of data;

three from your screenshot:

OHD record

HDR record

DTL record(s) that are related to the HDR row above...

yes, it's certainly possible.

i was thinking import down bloew but you mena tto export.

you want to select distinct provider, base don NPI number, as oneexport, adn a seperate export for...

try both slash r and slash n.

open the file in notepad++, which can give you the exact ascii character it is terminating in.

BWFC (3/10/2015)

---

Can anybody recommend a decent article about Dynamic File System tasks in SSIS. I've followed the instructions to the letter on all those I've found and every time...

this is a great example of using the wrong datatype. you have to jump through extra hoops to get data done right.

you'll have to convert to time or datetime, add...

most files end in slash r if they came from unix/other systems, or slash n if they came from windows.

try changing your bulk insert to use those:

\n = vbCrLf =...

bcp cannot help. bcp bulk loads data...it cannot execute each row as if it were a command.

open the file in SSMS and execute it instead. you might need to insert...

each database is seperate, so you need to explicitly add thelogin as a user to the other database

IF NOT EXISTS(SELECT * FROM sys.server_principals where type_desc='WINDOWS_LOGIN' AND name = 'omh\srinathp' )...

what does "still not working" mean?

is the end user using SSMS? queries? is there a specific error message?

rereading your original post, you said it's happening in one database only, so...

to view the table structure, you want to GRANT VIEW DEFINITION TO SomeUser instead of db_owner

that effectively allows them to see sys.tables/sys.columns, etc...all the metadata.

it lets them see procedure and...

a practitioner could have more than one location; you know, he works at Baptist East, Baptist North and Baptist South, so that would be normal to see the same provider...

i just used this powershell script, that i found after investigating your request

http://blogs.metcorpconsulting.com/tech/?p=343

i had to find and replace wierd left and right double quotes with normal double quotes to make...