1

Topic: To drag in basis of 20 sheets with parameters, how?

All greetings;
It is not assured that in this branch, but all the same.
There is a basis which considers important indexes. A problem that for calculation it is necessary to load many parameters.
Much it means simply to an ass. It is more than 20 sheets  with different labels.
As though it to wear out?? A shop reliably and without a nightmare.
That tried.
1) Packet SSIS.
On the computer of the user there lives packet SSIS which is caused by a macro from a file ex-fur-tree.
By a call to it the address of a file is fed and it fast imports all.
Variant excellent since it is programmed for a minute, however after update of a Visual Studio packet finishing appeared impossible. The infection and all hangs. Something is not pleasant to it in drivers .
2) C#.
Made  on WPF. Like imports, however a method  not fast since for each leaflet it is necessary to write the separate code of import. Thus WPF in our office almost nobody knows, therefore if I go on leave, there can be a problem. The big problem.
3) Macroes in .
Tried, but spat. Too much code turns out (really thousand lines) and to support all it in a normal state stupidly it is impossible.
4) MS SQL Master Data Services.
The file thought about it, however at the user on every month an ex-fur-tree. It turns out should copy each label from this file in other file where works MDS and then transits import. Long.
I while am declined to the second variant. To program long, however works...
There are still ideas?
Thanks.

2

Re: To drag in basis of 20 sheets with parameters, how?

User2155 ;
a file  to a sequel then anything to wear out and it will not be necessary.
Here type as:
[img=https://www.mssqltips.com/tipimages2/2018_Figure2-ConfigureLinkedServer.jpeg]

3

Re: To drag in basis of 20 sheets with parameters, how?

User2155 wrote:

There are still ideas?

5. To find the reason  item 1
6. To write a script,  a file on 20 separate csv-files. Further bcp.

4

Re: To drag in basis of 20 sheets with parameters, how?

The driver for the last versions  here:
https://www.microsoft.com/en-us/downloa … x?id=13255

5

Re: To drag in basis of 20 sheets with parameters, how?

User2155 wrote:

however after update of a Visual Studio packet finishing appeared impossible. The infection and all hangs. Something is not pleasant to it in drivers .

Not it?

https://support.microsoft.com/en-ca/help/4041681/windows-7-update-kb4041681 wrote:

Known issues in this update
Symptom
Installing this update may cause applications based on the Microsoft JET Database Engine (A Microsoft Access 2007 and older or non-Microsoft applications) to fail when creating or opening Microsoft Excel.xls files. The error message is, "Unexpected error from external database driver (1). (Microsoft JET Database Engine)".
Workaround
Download and install the Microsoft Access Database Engine 2010 Redistributable, and then modify the DB connection strings in Microsoft Excel to use ACE as a provider. Example: Change Provider=Microsoft. Jet. OLEDB.4.0 to Provider=Microsoft. ACE.OLEDB.12.0.
Microsoft is working on a resolution and will provide an update in an upcoming release.

6

Re: To drag in basis of 20 sheets with parameters, how?

Mind;
. Similar.
About  servers I somehow not . Too a variant, thanks.

7

Re: To drag in basis of 20 sheets with parameters, how?

invm wrote:

it is passed...
5. To find the reason  item 1
6. To write a script,  a file on 20 separate csv-files. Further bcp.

I Vote for point 6. There will be no hemorrhoids at change of versions of studio. Though the decision number of times the most technological and "correct"

8

Re: To drag in basis of 20 sheets with parameters, how?

Vorontsov wrote:

it is passed...
I vote for point 6. There will be no hemorrhoids at change of versions of studio. Though the decision number of times the most technological and "correct"

I thought that the criterion of technological correctness - "will not be hemorrhoids at change of versions of studio", "the code will be easily clear to following generations of programmers".
And that it is possible to do ,  and containers in a cloud, "will be technologically correct", but it is applicable only "to admire to the programmer".

9

Re: To drag in basis of 20 sheets with parameters, how?

alexeyvg wrote:

"the code will be easily clear to following generations of programmers"

It when you open the code a year or two from now and at once understand "that here is written".
. So it is impossible to me.

10

Re: To drag in basis of 20 sheets with parameters, how?

aleks222 wrote:

it is passed...
It when you open the code a year or two from now and at once understand "that here is written".
. So it is impossible to me.

What exactly cannot - be written, understood, opened or a year or two from now?

11

Re: To drag in basis of 20 sheets with parameters, how?

alexeyvg wrote:

it is passed...
I thought that the criterion of technological correctness - "will not be hemorrhoids at change of versions of studio", "the code will be easily clear to following generations of programmers".

"Correct" is quoted. Generally I to SSIS treat kindly, here to studio - it is bad.

12

Re: To drag in basis of 20 sheets with parameters, how?

aleks222 wrote:

it is passed...
It when you open the code a year or two from now and at once understand "that here is written".
. So it is impossible to me.

Let not that what directly to "understand" but that it would be possible to understand, most faster, to the stranger for comprehensible time.
Here I now corrected , as a result it was necessary plus on a minus in expression to replace that correctly would work.
So there some levels of calls, and each procedure that that does dynamic SQL, besides take the data and writes down result in created labels of a type [table _ <GUID>]
It is a tin.
The technological decision for import such that it would be possible to launch or have an opportunity it editing without long learning, to look at a handling flow if handling difficult, to look at the intermediate results as there should be a possibility to repeat import, and to make import on a sample of the data, for fast check and debugging.
Like obvious things, but, it appears, not for all. We tell, met import, which cannot be repeated, on the same data, for the same period (!?!?!?!)

13

Re: To drag in basis of 20 sheets with parameters, how?

Vorontsov wrote:

it is passed...
"Correct" is quoted. Generally I to SSIS treat kindly, here to studio - it is bad.

And, understood, thought, you it is serious :-)
Visual Studio it was good earlier, I only on it and worked with a sequel, with 90.
But now it is worse and worse, in the last version the syntax coloring generally disappeared. That is necessary that to select another :-(

14

Re: To drag in basis of 20 sheets with parameters, how?

alexeyvg wrote:

it is passed...
And, understood, thought, you it is serious :-)
Visual Studio it was good earlier, I only on it and worked with a sequel, with 90.
But now it is worse and worse, in the last version the syntax coloring generally disappeared. That is necessary that to select another :-(

At me 17.1 all colors

15

Re: To drag in basis of 20 sheets with parameters, how?

TaPaK wrote:

it is passed...
At me 17.1 all colors

Microsoft Visual Studio Community 2015. For a sequel the coloring is registered In adjustments.
Clear business, it depends on 100500 factors, here it and is sad. Bach, ceased to color, nothing to make.
Thus parse works, units uncovers-closes,  tables and columns prompts.
Bugs anybody will not correct, it now not in a trend.
Installed on  Windows computer, studio, colors? Means, all is normal.
Instead of administrators now  - studio with Windows in . Ceased to color, dates went, or that that still - took new . And to take better every day the new.
So nobody will understand.
[spoiler] Microsoft Visual Studio Community 2015
Version 14.0.25431.01 Update 3
. NET FRAMEWORK Microsoft
The version of 7/4/2046
The installed version: Community
Microsoft Visual Studio Tools for Applications 2015 00322-20000-00000-AA650
Microsoft Visual Studio Tools for Applications 2015
Visual Basic 2015 00322-20000-00000-AA650
Microsoft Visual Basic 2015
Visual C# 2015 00322-20000-00000-AA650
Microsoft Visual C# 2015
Visual C ++ 2015 00322-20000-00000-AA650
Microsoft Visual C ++ 2015
Visual F# 2015 00322-20000-00000-AA650
Microsoft Visual F# 2015
Packet SDK for Windows Phone 8.0 - RUS 00322-20000-00000-AA650
Packet SDK for Windows Phone 8.0 - RUS
ASP.NET Web Frameworks and Tools 2012.2 4.1.41102.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563
ASP.NET Web Frameworks and Tools 2013 5.2.40314.0
For additional information, visit http://www.asp.net/
ASP.NET and web tools 2015.1 (Beta8) 14.1.11107.0
ASP.NET and web tools 2015.1 (Beta8)
Command Bus, Event Stream and Async Manager Merq
Provides ICommandBus, IEventStream and IAsyncManager MEF services for loosely coupled A Visual Studio extension components communication and integration.
GitHub. VisualStudio 2.3.6.391
A Visual Studio Extension that brings the GitHub Flow into A Visual Studio.
Python Tools for A Visual Studio 2.2.50113.00
Python Tools for A Visual Studio provides IntelliSense, projects, templates, Interactive windows, and other support for Python developers.
Python Tools for A Visual Studio - Django Integration 2.2.50113.00
Provides templates and integration for the Django web framework.
Python Tools for A Visual Studio - Profiling Support 2.2.50113.00
Profiling support for Python projects.
SQL Server Data Tools 14.0.61705.170
Microsoft SQL Server Data Tools
SQL Server Integration Services
The designer of services of Microsoft SQL Server Integration Services
Version 14.0.600.250
TypeScript 1.8.36.0
Means TypeScript for a Visual Studio
Xamarin 4.2.1.62 (680125b)
Visual Studio extension to enable development for Xamarin.iOS and Xamarin. Android.
Xamarin. Android 7.0.2.37 (ce955cc)
Visual Studio extension to enable development for Xamarin. Android.
Xamarin.iOS 10.2.1.5 (44931ae)
Visual Studio extension to enable development for Xamarin.iOS.
Visualizer PreEmptive Analytics 1.2
The extension of Microsoft Visual Studio for visualization of the aggregated reports received from products PreEmptive Analytics.
The manager of packets NuGet 3.4.4
The manager of packets NuGet in a Visual Studio. The additional information about NuGet see the web site http://docs.nuget.org/.
Tools of mobile services of Microsoft Azure 1.4
Tools of mobile services of Microsoft Azure
The general tools Windows Azure 1.8
Gives the general services for usage by mobile services and Microsoft Azure tools.
Packet of means Application Insights for a Visual Studio 7.0.20622.1
Means Application Insights for a Visual Studio
System of projects JavaScript 2.0
System of projects JavaScript
Services of SQL Server Analysis Services 14.0.608.142
The designer of services of Microsoft SQL Server Analysis Services
Version 14.0.608.142
Services of SQL Server Reporting Services 14.0.608.142
Designers of Microsoft SQL Server Reporting Services
Version 14.0.608.142
Language service JavaScript 2.0
Language service JavaScript [/spoiler]

16

Re: To drag in basis of 20 sheets with parameters, how?

TaPaK wrote:

at me 17.1 all colors

Actually, 17.1 too does not color under certain conditions.
https://stackoverflow.com/questions/426 … tudio-2017
https://developercommunity.visualstudio … r-sql.html
I push a button to install  a packet, passage to page MS, there I select language,  - "We're sorry, this download is no longer available."
Here it all so works, through an ass.
For some years an error did not correct, in VS 2017 too did not correct, and at all did not send "on..." In arguing on the developercommunity.visualstudio.com, would be though clearly.
Smiling and speaking "we work for you" and "to us back coupling is very important".