I was wondering if someone could shed some light on my issue.
SSIS, can't use linked servers. I have to pull a view over from Server
2 and then run a query that references the view and a db on Server 1.
I've added the view to my project but for some reason I can't
reference the view from Server 2 and the db on Server 1 via a query. I
know this is a rookie mistake but any help would be greatly
appreciated.
.
Re: Localizing SQL Server Data ... The best way to limit the data transferred through the wire is to built ... if you do the join on the Server, that means that the same repeated data ... make a local query implying the local tables. ... to pull the changed records for those tables. ... (microsoft.public.access.modulesdaovba)
Re: CORRECTED TEST AND ANSWERS. ... What is version compatibility option useful for? ... Why can't an in-process ActiveX server be compiled as an EXE. ... the instance that oneObj currently references too. ... (microsoft.public.vb.general.discussion)
Re: Getting info from SQL DB ... most likely won't want to pull info on 30,000 People. ... load on the server as well. ... I would pick a number for the limit of one query, somewhere in the 20 to 50 ... and clear any unused parameters if the last batch has less than a full set. ... (microsoft.public.dotnet.languages.vb)
Re: Record source at runtime ... If you have defined a primary key, always include that in your query.... The way Jet works is to go to the server, find the tableand pull the ... it will pull the entire table of data. ...Limiting the fields doesn't matter much unless they are OLE ... (microsoft.public.access.formscoding)
Re: Range Names convert to Cell References ... but it seems to happen on either the Server or the PC that connects ... maybe it's not excel.... but it is reproducible on the work laptop.... persistently selecting the "Update remote references" and "Save external link ... (microsoft.public.excel.misc)
