ok, this is tried and true code for an ACE driver example i just retested.

the Sheet in excel is named AK.

does modifying either of these s to be your document...

i've run into issues where the \users folders are extra protected;

i always use something not under mydocuments\mydownlaods\mydesktop, like C:\Data\SQLImportTrim.xls instead of C:\Users\home\Desktop\SQLImportTrim.xls',

can you try moving the file to a non-protected...

adding quick consumable info for others to run with the ball:

;WITH TableA([date],[ID])

AS

(

SELECT '2012-09-21','1' UNION ALL

SELECT '2012-09-28','1' UNION ALL

SELECT '2012-10-05','1' UNION ALL

SELECT '2012-10-12','1' UNION ALL

SELECT '2012-10-19','1' UNION ALL

SELECT '2012-10-26','1' UNION ALL

SELECT...

well the est guess method based on column names might be a starting point, like you mentioned.

how about this:

if can you assume in your data sources that the first column,...

i think the issue is xp_cmshell;

as i remember it, with xp_cmdshell you are limited to a single pair of double quotes to a command, so ONE of your two paths...

JimK 28184 (7/16/2015)

---

Thanks, Alvin. It is a recurring problem, so we try to get as much info from those who know up front, but a lot of times nobody can...

So is everyone goi g to put in th3 same credentials, like Reportreader /SOMEPASSWORD? or will each user have a set 9f sql credentials

Yeah evey table, view, proc and function potentially, but you could script it from the metadata in sys.objects, a d i think you d be up and running.

that sounds like a [data source] or [shared data source] was added, but does not have saved credentials in it.

check the data source of the report you were prompted with.

so you had cross database queries,and because of the migration, one of the databases is now on another server?

if i have that right, i think you can create an empty...

i encountered that same error way back when i upgraded.

the error message is pretty clear.

if you post the statement we can show you a lot better, but basically , as...

it looks to me like only sys.tables and sys.views have the is_replicated column you are looking for.

select object_name(object_id) from sys.all_columns where name ='is_replicated'

use sys.objects instead of sys.views, and use a filter on type_desc column; WHERE type_desc IN('VIEW','ETC....)

SELECT DISTINCT type_desc FROM sys.objects

select which types you want to use.

Abhijit More (7/13/2015)

---

thxs Lowell the only concern I have in my files it may or may not have headers as well some file has Row Delimiter "CR LF"" and some...

lol Jeff that's evil;

i could do it with Excel Automation in a script task, but all the columns would end up being "column1" "column2" because the first row does not...